× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.