replacing control characters in procedures

[Baron]

Hi, I am using unload command to read from ml_script table and export it into text file. Problem: I get the text file in only one line (\\x0d, x0a, x09 are replacing the 'new line', 'space'...etc.) Question: how can I get the context in the text file without those special characters.

Thanks

[Breck_Carter · Accepted solution]

Try these UNLOAD options...

UNLOAD 
SELECT *
  FROM ml_script
TO 'c:\\temp\\ml_script.txt'
DELIMITED BY '' HEXADECIMAL OFF ESCAPES OFF QUOTES OFF;

[Baron · Accepted solution]

It has really worked!!! many thanks