Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Amazon Redshift
  3. PowerExchange for Amazon Redshift Configuration
  4. Amazon Redshift Connections
  5. PowerExchange for Amazon Redshift Data Objects
  6. Amazon Redshift Mappings
  7. Pushdown Optimization
  8. Amazon Redshift Lookup
  9. Appendix A: Amazon Redshift Datatype Reference
  10. Appendix B: Troubleshooting

PowerExchange for Amazon Redshift User Guide

PowerExchange for Amazon Redshift User Guide

Octal Values as DELIMITER and QUOTE

Octal Values as DELIMITER and QUOTE

In addition to printable ASCII characters, you can use octal values for printable and non-printable ASCII characters as DELIMITER and QUOTE.
To use a printable character as DELIMITER or QUOTE, you can either specify the ASCII character or the respective octal value. However, to use a non-printable character as DELIMITER or QUOTE, you must specify the respective octal value.
Example for a printable character:
DELIMITER=#
or
DELIMITER=\043
Example for a non-printable character, file separator:
QUOTE=\034
Octal values 000-037 and 177 represent non-printable characters and 040-176 represent printable characters.
The following table lists the recommended octal values, for QUOTE and DELIMITER in the Copy command and as DELIMITER in the Unload command, supported by Amazon Redshift:
Command Option
Recommended Octal Values
COPY QUOTE
001-010, 016-037, 041-054, 057, 073-100,133, 135-140, 173-177
COPY DELIMITER
001-011, 013, 014, 016, 017, 020-046, 050-054, 057, 073-133, 135-177
UNLOAD DELIMITER
001-011, 013, 014, 016, 017, 020-041, 043-045, 050-054, 056-133, 135-177

0 COMMENTS

We’d like to hear from you!