Results 1 to 2 of 2
  1. #1
    Join Date
    May 2015
    Posts
    1

    Unanswered: translate function

    Hello,
    Can you please let me know what exactly this function is doing here. we are exporting from DB2 and later will import to teradata. This function is being used in the export query to export the column1.

    TRANSLATE(column1,'',x'000A0D')

    thank you

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    If the value in column1 contains the hexadeximal values '000A0D' then remove these bytes (i.e. a binary-zero, or a linefeed, or a carriage-return character will be removed from the column1 value).

    You could have found this information in the docs also at this link below
    TRANSLATE scalar function

Posting Permissions

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