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";

To create usernames with lowercase letters when the system name is provided in uppercase letters, enclose the username in double quotation marks. You must also add single quotation marks around the username because the CREATE USER command connects to the shell terminal.

Example:

SYSTEM.ADMIN(ADMIN)=> create user '"localuser1@NZSQA.IBM.COM"' with password 'password' auth local;
CREATE USER
 
[nz@gt10-app-npshost ~]$ nzsql -u '"localuser1@NZSQA.IBM.COM"' -pw password