Trying to take the data from a Table (PF) in a library and convert the data into my ext described file using DDS.
(Included the DSPFFD of the file I'm working on)
Never worked with direct table files (PF in a library.) Getting CPF428A error message.
Basically the file contains BLOBs, and I've no idea how to process the file.
I have found things like adding
DCL-S MYCLOB SQLTYPE(CLOB:1000);
DCL-S MYBLOB SQLTYPE(BLOB:500);
DCL-S MYDBCLOB SQLTYPE(DBCLOB:400);
These convert into:
DCL-DS MYCLOB;
MYCLOB_LEN UNS(10);
MYCLOB_DATA CHAR(1000) CCSID(*JOBRUNMIX);
END-DS MYCLOB;
DCL-DS MYDBCLOB;
MYDBCLOB_LEN UNS(10);
MYDBCLOB_DATA GRAPH(400);
END-DS MYDBCLOB;
DCL-DS MYBLOB;
MYBLOB_LEN UNS(10);
MYBLOB_DATA CHAR(500) CCSID(*HEX);
END-DS MYBLOB;
What the heck do I do with these fields? How are they used within the SQLLERPG program.
------------------------------
Phillip Knox
------------------------------