By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,279 Members | 1,680 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,279 IT Pros & Developers. It's quick & easy.

seek trick to insert a clob value from the command line

P: n/a
Is there a command line trick that inserta ascii text into a CLOB
column?

Thanks.

Aug 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Aug 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.