Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008
    Posts
    24

    Smile Unanswered: problem with LOAD

    HI ,

    Im using LOAD FROM command to load a unl(pipe delimited) file to table.

    The operation fails bcoz of a backslash symbol (\) in a data field. It works fine when i remove the backslash and load the data.

    So, how can i make it work with the backslash, as i have to load the original data without making any changes manually.

    Thanks

  2. #2
    Join Date
    Sep 2010
    Location
    Germany, Brunswick
    Posts
    55
    Try two backslashes instead of one.
    WilhelmW

  3. #3
    Join Date
    May 2008
    Posts
    24
    Quote Originally Posted by InformixWilli View Post
    Try two backslashes instead of one.
    That works fine, but is it possible to inactivate these kind of symbols during the load process? Bcoz, my primary aim is not to manipulate the unl file.

    Thanks

  4. #4
    Join Date
    Sep 2010
    Location
    Germany, Brunswick
    Posts
    55
    I think thats not possible!

    Here you can find more informations about load and backslash: LOAD statement
    WilhelmW

Posting Permissions

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