Skip to Content

Specifying object names in your syntax

Note the following information about specifying object names in your UNLOAD PLUS syntax:

  • You can use an alias or synonym wherever the syntax diagram shows a table name or view name.
  • If you use SQL reserved words or UNLOAD PLUS syntax keywords as object names, we recommend that you delimit the reserved words or keywords to prevent syntax errors.

Related topic

Command and syntax reference

  • UNLOAD PLUS does not support Unicode table or view names.
  • UNLOAD PLUS does not support delimited object names that do not have a character representation in EBCDIC.
  • UNLOAD PLUS supports the use of the double-byte character set (DBCS). You can use DBCS characters in Db2 identifiers such as tables, columns, or view names.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

UNLOAD PLUS for DB2 13.1