seek trick to insert a clob value from the command line
This is a discussion on seek trick to insert a clob value from the command line within the DB2 forums, part of the Database Server Software category; --> Is there a command line trick that inserta ascii text into a CLOB column? Thanks....
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:54 AM
| ||||
| ||||
 Re: seek trick to insert a clob value from the command line gimme_this_gimme_that@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      |
Linear Mode
