Home > IT Answers > AS/400 > How to define a CLOB in SQLRPGLE Stored Proce...
OldButNewbie
5 pts.
 How to define a CLOB in SQLRPGLE Stored Procedure
iSeries RPG programming, iSeries V5R4MO
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: Feb 7, 2012  1:11 PM GMT
UPDATED: March 17, 2012  1:51:46 AM GMT
RELATED QUESTIONS
TomLiotta
66,935 pts.
Answer Wiki:
Last Wiki Answer Submitted:  Mar 17, 2012  1:51 AM (GMT)  by  TomLiotta   66,935 pts.
Latest Answer Wiki Contributors:  Rebek4love   3,500 pts., MTidmarsh   150 pts., Glory35   4,765 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

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

TomLiotta
 66,935 pts.