Hi Alexandre,
AFAIK there is no way to insert blob's with 'normal SQL'
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: Re: Antwort: [DB2EUG]
Insert BLOB value
05.02.2003 17:28|
|
--------------------------------+----------------------------------------------------------------------------
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
