Trying to use SQLRPGLE to create a Stored procedure. When I use a data type of CLOB (OUT: XMLDATA CLOB (64 K)) I get SQL0451 error (Attributes of parameter 9 not valid for procedure or function AVSESPLOAD in *N) Can anyone tell me what I should be doing. I need to define a 64K output string for this stored procedure. Machine version: V5R4M0, Option(*CVTDT)
Software/Hardware used:
iSeries (V5R4MO)
ASKED:
February 7, 2012 1:11 PM
UPDATED:
March 17, 2012 1:51 AM
I haven’t done it for a stored proc, so I can only point to some basic documentation. See the LOB host variables in ILE RPG applications that use SQL topic for some ILE RPG coding examples for definitions.
Tom