Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    76

    Unanswered: Loading NCLOB with SQL Loader.

    Hi,

    I'm having a problem while loading an exported file from an Informix database, in wich there is an column of the NCLOB datatype.
    The export went right, and the NCLOB contects is allright, but when I am loading it I'm experiencing some issues.

    I have 3 columns:
    1- CHAR(36)
    2- Integer
    3- NCLOB

    The first column is allways filled and the containg data is allways 36 chars length.
    The second column has numbers from 1 to 10000 and is Mandatory as well
    The third column, the NCLOB column is allways filled too, but when I am loading it using the Position I'm having problems.

    I cannot use the Delimeter option, because Informix exports data with "|" separator, but the contents of the NCLOB column have several "|" and therefore I cannot use it as a separator.

    When I use POSITION to determine where both fields begin and ends, I have the problem of variable length.

    Can anyone help me with this?

    Thanks!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Can anyone help me with this?
    Can you change what gets generated to be as follows?

    1- CHAR(36)
    2- Integer
    3- Length of following
    4- NCLOB
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Posts
    76
    Hi anacedent.

    First of all thanks for your quick reply.

    The file generated is a regular exported file from Informix. I dont know if there is any way to do that.
    Is there any other way to work around it??

    Thanks!

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is there any other way to work around it??
    use EXTERNAL TABLE instead of sqlldr?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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