dbsql limitations

This topic includes a list of limitations for the dbsql command.

Syntax for generating statistics

Currently, the dbsql command supports only the Netezza syntax for statistics generation. Instead of runstats, use:

generate statistics on t1

Single-line comment dashes

The two dashes (--) of a single-line comment are not supported within BEGIN/END blocks. Replace a single-line comment with a multi-line comment (/* and */).

Not supported single-line comment:


CREATE OR REPLACE FUNCTION MY_ADD(IN A INTEGER, IN B INTEGER)
RETURNS INTEGER
BEGIN
    RETURN A + B;
    -- this comment causes error in begin/end block
END@

Supported multi-line comment:


CREATE OR REPLACE FUNCTION MY_ADD(IN A INTEGER, IN B INTEGER)
RETURNS INTEGER
BEGIN
    RETURN A + B;
    /* such comment is OK inside begin/end block */
END@