Question posted by: msmithuk
(Guest)
on
July 23rd, 2008 02:45 PM
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.PPMS999T
AUDIT NONE
;
If there is anything more I need to supply please just ask.
Much appreciated
Moira
Not the answer you were looking for? Post your question . . .
183,964 Experts ready to help you find a solution.
Sign up for a free account, or
Login (if you're already a member).
