Hi,
I am writing a PL/1 program which will be reading a DB2 Table which
has a column defined as a CLOB.
Therefore, I should use DCLGEN to obtain accurate SQL DECLARE TABLE
statements.
However I do not have authority, at this company, to use DCLGEN and am
trying to learn more about CLOBs, so trying to bypass any formal
processes.
Is there anyone who could supply the relevant SQL DECLARE TABLE and
relevant PL/1 host variables for the following table:
CREATE TABLE LSTEK54.PP_MRA_ SMT(
SEQ_NUMBER INTEGER GENERATED ALWAYS AS IDENTITY,
TYPE CHAR(2) NOT NULL,
LOTS_OF_DATA CLOB(4M),
PRIMARY KEY (SEQ_NUMBER)
)IN LSTEK54.PPMS999 T
AUDIT NONE
;
If there is anything more I need to supply please just ask.
Much appreciated
Moira
I am writing a PL/1 program which will be reading a DB2 Table which
has a column defined as a CLOB.
Therefore, I should use DCLGEN to obtain accurate SQL DECLARE TABLE
statements.
However I do not have authority, at this company, to use DCLGEN and am
trying to learn more about CLOBs, so trying to bypass any formal
processes.
Is there anyone who could supply the relevant SQL DECLARE TABLE and
relevant PL/1 host variables for the following table:
CREATE TABLE LSTEK54.PP_MRA_ SMT(
SEQ_NUMBER INTEGER GENERATED ALWAYS AS IDENTITY,
TYPE CHAR(2) NOT NULL,
LOTS_OF_DATA CLOB(4M),
PRIMARY KEY (SEQ_NUMBER)
)IN LSTEK54.PPMS999 T
AUDIT NONE
;
If there is anything more I need to supply please just ask.
Much appreciated
Moira