Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010
    Posts
    3

    Unanswered: Import flat file in db2 table using a clob datatype

    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.commenttable

    27628

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    can you display the ddl of the table and the export/import command
    version and platform could be useful also
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Mar 2010
    Posts
    3
    I am using version 9.5. And i am using the import utility in db2. Here is the CREATE TABLE "SQLJ "."COMMENTS" (
    "ID" INTEGER NOT NULL ,
    "COMMENTS" CLOB(32768) LOGGED NOT COMPACT )
    IN "USERSPACE1" ;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •