TAFJ bulk insert in unix
- tester111
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 29
- Thank you received: 0
6 years 8 months 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
Less
More
- Posts: 29
- Thank you received: 0
6 years 8 months 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.
- madhulatha
- Offline
- Junior Member
Less
More
- Posts: 25
- Thank you received: 6
6 years 8 months 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 ...
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 ...
Please Log in or Create an account to join the conversation.
Time to create page: 0.075 seconds