Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Massachusetts
    Posts
    27

    Question Unanswered: Loading LOB data into a tablespace

    Hi,

    DB2 v7.1 for OS/390

    Does anyone has any experience in Unloading/Loading tables/tablespaces with LOB columns?

    I tried unloading a table which has LOB columns. First I got the error 'LOGICAL RECORD LENGTH OF OUTPUT RECORD EXCEEDED THE LIMIT FOR TABLE'. Manual suggested using the keyword NOPAD while unloading. I did and it was successful.

    Now the problem is I am not able to load this data back. IBM Load utility discards the records saying..

    "RECORD (1) WILL BE DISCARDED DUE TO INVALID 'RPT_RSLT' COLUMN SPECIFICATION FOR table name".

    This is my input load card (generated by previous Unload execution):

    LOAD DATA LOG NO REPLACE
    EBCDIC CCSID(37, 0, 0)
    INTO TABLE "table_name" WHEN(1:2=X'0005')
    IGNOREFIELDS YES
    ("DSN_ROWID " POSITION(3) ROWID,
    "RPT_ID " POSITION(*) DECIMAL,
    "RPT_RSLT " POSITION(*) CLOB)

    These are the columns of the table which I am trying to load -

    COLUMN NAME----------COLTYPE---LENGTH

    ROWID------------------ROWID----17
    RPT_ID------------------DECIMAL--15
    RPT_RSLT---------------CLOB------4

    I am wondering about this 'IGNOREFIELDS YES' clause. I guess since the first column is ROWID which is GENERATED AS ALWAYS, it is trying to skip it and trying to load the rest of the data. But why isn't this working?

    Can someone help please ? Suggestions, tips ..anything?
    "It is Monday morning 3:02 AM. What is your SQL response time ?"

  2. #2
    Join Date
    Jan 2004
    Location
    Zuerich, Switzerland
    Posts
    13
    have you checked the Utilties Guide?

    her's what it say about loading ROWID columns:

    If you want to include the data from the identity column or ROWID
    column when you load the unloaded data into a table, the identity
    column or ROWID column in the target table must be defined as
    GENERATED BY DEFAULT.

Posting Permissions

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