dbsql command miscellaneous options

The dbsql command offers several options for specifying comments, literals, and labels.

The dbsql command has the following command-line options that you use when you run queries:

--

Two dashes denote the beginning of a single-line comment.

Note: Single-line comments are not supported within BEGIN/END blocks. For more information, see dbsql limitations.

/*

Forward slash and an asterisk denote the beginning of a multi-line comment.

*/

Asterisk and forward slash denote the end of a multi-line comment.

'literal'

Use single quotation marks around literals. For example, ‘May 10, 2015’ or ‘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 uppercase. If you want to use mixed case, spaces, or both, you must use delimited identifiers and specify double quotation marks around the value. For example:

CREATE TABLE "Emp Table" (emp_id integer, emp_name char(20)); 
SELECT emp_id FROM "Emp Table";