I found a service program which will wrap text for output and call it LINEWRAP. There is a Module and Service program in my library list. I also followed the instructions to create an SQL procedure. The program works fine with Interactive SQL. However, when try to code it in my SQLRPGLE program, I get an error the object LINEWRAP does not exist.
If my library list includes the objects, what are they not found, but yet OK using Interactive SQL. I can't figure out what I'm missing.
If my library list includes the objects, what are they not found, but yet OK using Interactive SQL. I can't figure out what I'm missing.
exec sql DECLARE C4 CURSOR FOR
Select lineno, linetext
From Table(LINEWRAP(:splitline,100)) Comments
FOR READ ONLY ;
exec sql OPEN C4;
exec sql FETCH C4 FOR 3 ROWS INTO :lines ;
exec sql CLOSE C4;
Select lineno, linetext
From Table(LINEWRAP(:splitline,100)) Comments
FOR READ ONLY ;
exec sql OPEN C4;
exec sql FETCH C4 FOR 3 ROWS INTO :lines ;
exec sql CLOSE C4;
Comment