Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Boisbriand, Qc, Canada
    Posts
    25

    Unanswered: dbimport cannot read dbexport dump

    Hello everyone

    I did a dbexport.

    When I tried to do a dbimport of it, I obtain an error.
    -----------------
    create unique index "sapr3".aablg~0 on "sapr3".aablg (mandt,belnr,
    pageno);
    *** prepare sqlobj
    202 - An illegal character has been found in the statement.
    ----------------

    I know there is a ~ in the index name.
    It is part of the index name.

    Now, how do we force informix to create that index name like dbexport specified? (including the ~ )


    I am on Informix 7.31UD1

    stjacqd

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    Please set environment variable DELIMIDENT=1
    Then run dbimport.

    Gustavo.

Posting Permissions

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