4. SQL Statements : COPY VWLOAD : vwload Escape Sequences
 
Share this page                  
vwload Escape Sequences
To specify control characters in the vwload command, you must use an escape sequence. An escape sequence is initiated by a \ character. Valid escape sequences are:
Escape Sequence
Description
\a
Bell (alert)
\b
Back space
\f
Form feed
\n
Newline
\r
Carriage return
\t
Tab
\v
Vertical tab
\nnn
The character with octal code value nnn
\uxxxx
The 2-byte Unicode code point with hexadecimal value xxxx
\\
\ character
Note:  Certain special characters, such as \, ", ‘, and |, must be protected from interpretation by the command shell by using the appropriate quoting and escaping mechanisms provided by the shell. This does not apply to Actian Director, which automatically takes care of such formatting.