UNLOAD TABLE statement
636
ESCAPES option With ESCAPES on (the default), backslash-character
combinations are used to identify special characters where necessary on
export.
FORMAT option Outputs data in either ASCII format or in BCP out
format.
HEXADECIMAL option By default, HEXADECIMAL is ON. Binary
column values are written as 0xnnnnnn…, where each n is a hexadecimal
digit. It is important to use HEXADECIMAL ON when dealing with multi-
byte character sets.
ORDER option With ORDER on (the default), the exported data is
ordered by primary key values. With ORDER off, the data is exported in the
same order you see when selecting from the table without an ORDER BY
clause.
Exporting is slower with ORDER on. However, reloading using the LOAD
TABLE statement is quicker because of the simplicity of the indexing step.
QUOTES option With QUOTES turned on (the default), single quotes are
placed around all exported strings.
♦
SQL/92 Vendor extension.
♦
Sybase UNLOAD TABLE is not supported by Adaptive Server
Enterprise. Similar functionality is provided by the Adaptive Server
Enterprise bulk copy utility (bcp).
Standards and
compatibility
To Next Page
Loading...