MVSFORUMS.com

[viswanathan]

We are using XML PARSE in our COBOL Stored Procedure Code, where we receive the input in XML format of size ~5mb (Input parm is defined as CLOB Datatype).

We are encountering error (SOC 4) if the size is > 2mb.
If we pass the input of size ~ 2mb, then the Stored Procedure works fine.

Is there any specific limit for XML Parse?

[papadi]

Look here (near the bottom):
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/igy3lr50/APPENDIX1.2

There may be a size issue with the stored procedure (rather than COBOL).

You might try cloning the sp code into just a callable routine of a new name with no db2 and see if the problem persists.
_________________
All the best,

di

[viswanathan]

Language element :
XML PARSE statement, maximum size of identifier


Compiler limit : 134,180,862 bytes (67,090,431 national character positions)

Thanks for the info papadi!

[papadi]

You're welcome