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
