Import flat file in db2 table using a clob datatype

[lolo87]

I exported a one column table using datatype text from SQL. As a txt and tried as Del file.

I am trying to import this file in DB2.
I created a table in DB2 using one column CLOB.
Every time I import using DB2 tool I receive an error message for every entry.

[IBM][CLI Driver][db2/sun64] SQL0423N Locator variable "1" does not currently represent any value. SQLSTATE=0f001

My text in the table is long. Am I using the correct datatype for long text data?

I tried different datatype and it works but truncates the data.

Here is my longest record.

select max(datalength( Comments)) from dbo.commenttabl e

27628

[vijay2082]

Hi,

try both the solutions and see if that helps. If not then provide the messages file durig the import, the table ddl and the db2diag.log file entry for the complete operation.

http://www-01.ibm.com/support/docview.wss?uid=swg21216804

http://www-01.ibm.com/support/docview.wss?uid=swg21500631

Cheers, Vijay