|
I have gained access to an API and am receiving four test records, but they are not loading to the database. The docsReady array is blank except that the num_Docs field of each element contains the same value (1077952576.)
I am getting a message:
Error MCH3401 occurred while running the program or procedure for the DATA-INTO
I don't know what I may be doing incorrectly. Can you help?
Thank you,
Scott
dcl-s buffer VARCHAR(160000);
dcl-ds docsReady dim(9999) qualified;
num_docs INT(10);
groupID ZONED(5:0);
groupName VARCHAR(40);
recorderApprovedDate CHAR(23);
sequence ZONED(3:0);
priaDocObjectID ZONED(6:0);
end-ds;
Data-Into docsReady
%data( buffer : 'case=any countPrefix=num_ allowExtra=yes' )
%parser( 'YAJL/YAJLINTO' );
[
{
"groupID":86559,
"groupName":"XYZ COMPANY",
"recorderApprovedDate":"2019-05-21 19:40:50.471",
"sequence":1,
"priaDocObjectID":100470
},
{
"groupID":86559,
"groupName":"XYZ COMPANY",
"recorderApprovedDate":"2019-05-21 19:40:50.471",
"sequence":2,
"priaDocObjectID":100469
},
{
"groupID":86559,
"groupName":"XYZ COMPANY",
"recorderApprovedDate":"2019-05-21 19:40:50.471",
"sequence":3,
"priaDocObjectID":100468
},
{
"groupID":86559,
"groupName":"XYZ COMPANY",
"recorderApprovedDate":"2019-05-21 19:40:50.471",
"sequence":4,
"priaDocObjectID":100471
}
]
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.