seek trick to insert a clob value from the command line

[gimme_this_gimme_that]

Is there a command line trick that inserta ascii text into a CLOB
column?

Thanks.

[Knut Stolze]

gi*******************@yahoo.com wrote:

Is there a command line trick that inserta ascii text into a CLOB
column?

No, there isn't. CLOBs are just like any other data type:

CREATE TABLE t (
id INT,
lob CLOB(1M)
)@
DB20000I The SQL command completed successfully.

INSERT INTO t VALUES ( 1, 'lob data' )@
DB20000I The SQL command completed successfully.

Things are a bit different if you have UDFs in the picture. Then you may
have to tell DB2 the specific type so that function resolution works
properly.

INSERT INTO t VALUES ( 2, CLOB('lob data') )@

--
Knut Stolze
DB2 Information Integration Development
IBM Germany