Thank you Scott.
Looks like the issue was with DS declaration. Corrected it and now working fine with array of 29K elements.
Will change it to using %Handler and check it.
Search found 11 matches
- Fri Jul 28, 2023 9:05 pm
- Forum: RPG IV
- Topic: Huge XML file processing from IFS (IBMi)
- Replies: 8
- Views: 35129
- Thu Jul 27, 2023 1:54 pm
- Forum: RPG IV
- Topic: Huge XML file processing from IFS (IBMi)
- Replies: 8
- Views: 35129
Re: Huge XML file processing from IFS (IBMi)
Trying to use XML-INTO command to get data from XML file from IFS and got below error, due to usage of CDATA. XML Element: <PriceListID><![CDATA[1]]></PriceListID> DS subfield declaration: PriceListID varchar(10); Error Message: The XML document does not match the RPG variable; reason code 5. Reason...
- Tue Jul 25, 2023 9:37 pm
- Forum: RPG IV
- Topic: Huge XML file processing from IFS (IBMi)
- Replies: 8
- Views: 35129
Re: Huge XML file processing from IFS (IBMi)
Sure Scott, will check it, thanks!
- Tue Jul 25, 2023 7:07 pm
- Forum: RPG IV
- Topic: Huge XML file processing from IFS (IBMi)
- Replies: 8
- Views: 35129
Re: Huge XML file processing from IFS (IBMi)
Thanks for your inputs Scott.
Will try XML-INTO with %HANDLER first. Are there any samples to refer for this?
Will try XML-INTO with %HANDLER first. Are there any samples to refer for this?
- Tue Jul 25, 2023 3:21 pm
- Forum: RPG IV
- Topic: Huge XML file processing from IFS (IBMi)
- Replies: 8
- Views: 35129
Huge XML file processing from IFS (IBMi)
Hi All, Would like to get your thoughts on the situation below - Need to process a huge XML (around 20MB size currently and could grow) from IFS folder using ILE RPG. One option is to use RPG's built-in XML-INTO. Understand that there is a size limitation to use this function. Would this be a better...
- Tue May 09, 2023 9:59 pm
- Forum: General
- Topic: RPGMAIL emailing errors out
- Replies: 6
- Views: 28624
Re: RPGMAIL emailing errors out
Thanks jonboy49 for your assistance. Looks like we need to find a better alternative of RPGMAIL.
Will check on that.
Will check on that.
- Mon May 08, 2023 10:01 pm
- Forum: General
- Topic: RPGMAIL emailing errors out
- Replies: 6
- Views: 28624
Re: RPGMAIL emailing errors out
Thanks jonboy49, will look into your suggestion on getting a different tool, if this could not be resolved.
Thanks Scott. Would you know how to make the RPGMail class available in classpath. Have not done it before.
Thanks Scott. Would you know how to make the RPGMail class available in classpath. Have not done it before.
- Mon May 08, 2023 1:51 pm
- Forum: General
- Topic: RPGMAIL emailing errors out
- Replies: 6
- Views: 28624
RPGMAIL emailing errors out
Hello, In a new API (part of apache server configuration), using RPGMAIL to send email. When testing the API through POSTMAN, email process errors out with RNX0301 while calling RPGMailConstructor. Any thoughts on why is it occurring or anyone came across this error and how to resolve it? The error ...
- Tue May 02, 2023 5:48 pm
- Forum: YAJL-ILE
- Topic: Lexical Error while reading JSON payload through webservice
- Replies: 3
- Views: 13258
Re: Lexical Error while reading JSON payload through webservice
Hello Scott,
Found what got missed. When testing through PostMan, believe it did not like manually added CRLF (from notepad sample). Removed all line breaks and made it as a single continuous string and submitted as JSON, and now no error message
Thank you!
Found what got missed. When testing through PostMan, believe it did not like manually added CRLF (from notepad sample). Removed all line breaks and made it as a single continuous string and submitted as JSON, and now no error message

Thank you!
- Tue May 02, 2023 1:25 pm
- Forum: YAJL-ILE
- Topic: Lexical Error while reading JSON payload through webservice
- Replies: 3
- Views: 13258
Re: Lexical Error while reading JSON payload through webservice
Hello Scott, Never mind, the actual JSON has more fields, when truncated to paste here, forgot to remove the comma. Already checked with json formatter to confirm the payload and did not get any errors. Again did copy/paste the whole JSON file content into jsonlint and when validated, got the result...