Alexandre,
perhaps you find something within the /sqllib/samples directory.
There are a lot of samples, working with blob's.
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
-
::: 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
