TAFJ bulk insert in unix

  • tester111
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 4 days ago #21684 by tester111
TAFJ bulk insert in unix was created by tester111
i am using TAFJ unix platform. i want to update the record by OFS. but can i use the OFS for bulk insert. now i found that the response is slow and sometime response with the word in the same location (it is hard to check the response one by one). how can i check if all the record update success or not? or any advise (the method) how can i perform bulk update using ofs?

Please Log in or Create an account to join the conversation.

  • tester111
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 3 days ago #21688 by tester111
Replied by tester111 on topic TAFJ bulk insert in unix
anyone help

Please Log in or Create an account to join the conversation.

More
6 years 23 hours ago #21691 by madhulatha
Replied by madhulatha on topic TAFJ bulk insert in unix
Hi,
Please find the example for checking response
using WRITESEQ write arrays into csv files, Y.LINE.CNT +='1' is assigned in loop, for getting line number in incoming csv file

CALL OFS.CALL.BULK.MANAGER(Y.SOURCE.ID,OFSRECORD,OFS.RES,OFS.ERR)
RESP = FIELD(OFS.RES,',',1)
ACC.RESP=FIELD(RESP,'/',3)
IF ACC.RESP EQ '1' THEN
Y.ARR<-1>=Y.LINE.CNT:"#":OFS.RES ;success message response
END ELSE
Y.ERR.ARR<-1>=Y.LINE.CNT:"#":OFS.RES:"#":OFSRECORD ;Error message
END


output:
sample incoming csv file:
0001 ,AC,110175,60,20130326,110191,USD,USD
0002 ,AC,110175,50,201303,110191,AED,USD ;given wrong date format
0003 ,AC,110248,40,20130326,110256,USD,USD
sample Output response csv file:
0001 1#<requests><request>FT1322402164//1,TRANSACTION.TYPE:1:1=AC,DEBIT.ACCT.NO:1:1=110175,...
0002 3#<requests><request>FT1322402165//1,TRANSACTION.TYPE:1:1=AC,DEBIT.ACCT.NO:1:1=110248,...
0003 2#FT1322402165//-1/NO,DEBIT.VALUE.DATE:1:1=MONTH CAN BE (0)1-12 ...
Attachments:

Please Log in or Create an account to join the conversation.

Time to create page: 0.102 seconds