RE: SQL table function IFS_READ

I think you are misunderstanding the "pointer error" reference in my
email. I am referring to messages in the job log related to the SQLSTATE
38501.

I know I'm getting a clob from the fetch. This is the definition of the DS
that the FETCH statement references.

DCL-DS IFS_Input;
LineNumber INT(10) INZ;
Clob SQLTYPE(CLOB:2000000) INZ;
END-DS;

I haven't been able to find any Google results for both IFS_READ and 38501
SQL state. I have opened a ticket with IBM. Hopefully, they can either
tell me what I'm doing wrong or fix the error.


From: Darren Strong

IFS_READ normally returns a CLOB(2G) doesn't it? It seems like you'd be

getting pointers on every read. Maybe trying casting the results as a
character string within the SQL instead of the select *.

Something like:
EXEC SQL DECLARE CURSOR1 CURSOR FOR SELECT cast(line as char(500)) FROM

TABLE(QSYS2.IFS_READ(PATH_NAME => :FileName))