Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2011
    Posts
    4

    Unanswered: ASCII characters loaded while running DB2 Load Utility

    Hi,

    I am using the DB2 Load utility to load a delimited file , and am facing a strange issue.

    After the delimited file gets loaded into the DB , when I run a select query on the table , it shows the loaded rows along with certain ascii values, in this case the ascii value which is 239 , equivalent to a cube

    The delimited file does not contain any such data , then why is DB2 Load utility loading records with the ascii value.

    Any help in this regard will be greatly appreciated.

    Thanks ,
    Vivek

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by vivek122 View Post

    The delimited file does not contain any such data
    How did you verify that?

  3. #3
    Join Date
    Aug 2011
    Posts
    4
    I verified by opening it , since i had access to the same.

  4. #4
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    vivek122, Did you view it with a Hex editor? Some of those ASCII characters and non-printable and don't show up on normal viewing.

  5. #5
    Join Date
    Aug 2011
    Posts
    4
    Hi Stealth_DBA ,

    I will try it out and update the post here...

    Thanks

Tags for this Thread

Posting Permissions

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