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
-
::: 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
