TAFJ bulk insert in unix

  • tester111
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 28
  • Karma: -5
  • Thank you received: 0

tester111 created the topic: TAFJ bulk insert in unix

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?
#21684

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

  • tester111
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 28
  • Karma: -5
  • Thank you received: 0

tester111 replied the topic: TAFJ bulk insert in unix

anyone help
#21688

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

  • Posts: 25
  • Karma: 1
  • Thank you received: 6

madhulatha replied the 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 ...
#21691
Attachments:

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

Time to create page: 0.188 seconds