Miscellaneous command options
The nzsql command has the following command-line options that you use when you
run queries:
- --
- Two dashes denote the beginning of a single-line comment.
- /*
- Forward slash and an asterisk denote the beginning of a multiline comment.
- */
- Asterisk and forward slash denote the end of a multiline comment.
- 'literal'
- Use single quotation marks around literals. For example,
‘May 10, 2000’
,‘Netezza Performance Server’
,‘US’
. Use a pair of single quotation marks when you want to embed a single quotation mark. For example,‘Mark''s Test'
. - "label"
- Use double quotation marks around labels. For example,
SELECT lst_name AS "Employee Last Name" FROM emp_table;
- Identifiers
- The system automatically converts identifiers, such as database, table, and column names, to the
default system case, which is Upper on new systems. If you want to use mixed case, spaces, or both,
you must use double quotation marks around the identifier. For example:
CREATE TABLE "Emp Table" (emp_id integer, emp_name char(20)); SELECT emp_id FROM "Emp Table";