Hi, Joachim! > perhaps you find something within the > /sqllib/samples directory. > There are a lot of samples, working with blob's.
Unfortunately, all those samples are related to embedded SQL code, and not SQL code executed via command line interface and/or command center. I know how to work with BLOBs in a C program etc., but hte question is - how to do this using SQL in db2clp? Is there a way to do this at all? Alexandre. > > 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: > Joachim Mueller > <[EMAIL PROTECTED]> > om>| Kopie: > [EMAIL PROTECTED] > > | Thema: > Re: Antwort: [DB2EUG] Insert BLOB value > > 05.02.2003 17:16| > > > | > > > > --------------------------------+---------------------------------------------------------------------------- > > > > > > 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 > > > > __________________________________________________ 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
