Home > IT Answers > AS/400 > How to define a CLOB in SQLRPGLE Stored Procedure
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: February 7, 2012  1:11 PM
UPDATED: March 17, 2012  1:51 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,380 pts. , Michael Tidmarsh   0 pts.
To see all 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
 107,735 pts.