Thanks, Joachim, but I am specifically interested in running SQL code, not using DB2 commands.
--- Joachim Mueller <[EMAIL PROTECTED]> wrote: > > Hi Alexandre, > > use db2's load commad... > > Best regards > > Joachim M�ller > -- > DOUGLAS Informatik & Service GmbH > Datenbankmanagement > Douglas Holding AG, Kabeler Str. 4, 58099 Hagen > Tel.:+49-2331-690-249,Fax:+49-2331-690-78-249 > Mobile: +49-170-2221-249 > > > > > --------------------------------+---------------------------------------------------------------------------- > > Alexandre Efremov| > > > <[EMAIL PROTECTED]| An: > [EMAIL PROTECTED] > > om>| Kopie: > > > Gesendet von:| Thema: > [DB2EUG] Insert BLOB value > > [EMAIL PROTECTED]| > > > rg| > > > | > > > | > > > 05.02.2003 16:16| > > > Bitte antworten an| > > > Alexandre Efremov| > > > | > > > > --------------------------------+---------------------------------------------------------------------------- > > > > > > Hi, everyone! > > Is there a way to insert BLOB value to the table via > command line interface and/or command center? My > numerous attempts to do so failed. Then I used SQL > assist to generate INSERT statement. SQL assist > created the code like this: > > INSERT INTO > BLOBTAB > ( > ID, > NAME, > TEXT > ) > VALUES > ( > 1, > 'One', > 41424241 > ) > > But on attempt to run it, it failed with the > following > error message: > > SQL0408N A value is not compatible with the data > type > of its assignment target. Target name is "TEXT". > SQLSTATE=42821 > > So, how do I insert BLOB data using command line > interface? Another question - is there a way to > specify the name of disk file as a source for LOB > data? > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > - > ::: When replying to the list, please use > 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to > [EMAIL PROTECTED] > *** For more information, check > http://www.db2eug.uni.cc > > > > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
