Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    16

    Unanswered: Problem With Export

    Hi All,

    I am using UDB V8.2 on AIX . When I do an EXPORT in DEL format , it gives a
    SQL3100W on certain rows.

    mainly, This warning occurs on rows that do not have any columns that are
    over 254 chars.

    When I go and look at the .DEL export file , the rows that got the
    warning are broken into two and appear as two seperate lines in the unix
    file.

    for example let us say that the table has 5 columns A,B,C,D and E and
    let a1,b1,c1,d1,e1 represent the data exported then my file looks like this

    a1,b1,c1,d1,e1
    a2,b2,c2,d2,e2
    a3,b3,c3 <--- Line that gives the SQL3100W
    d3,e3
    a4,b4,c4 <--- Line that gives the SQL3100W
    d4,e4

    and when i do it with the .IXF then i am not getting any errors. Please explain me why it is happening and also please do explain me the difference.

    Your help is really appreciated.

    Thanks in advance.

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    In Command ref on page 365 second paragraph it says that if the char col is greater then 254 and using DEL format only you will get an error. IXF stores data diferently then DEL does, thus not effected by this limitation.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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