Command feedback

When you issue an SQL command, you either succeed or receive an error. In either case, the system provides feedback that you can use in a script.

The system feedback for inserts, updates, and deletes shows you the number of rows that are acted upon. The feedback for inserts includes an extra zero before the actual number (because of a historical artifact). Sample commands (shown in bold) and the command feedback follows:

nzsql
CREATE TABLE test1 (col1 INTEGER, col2 INTEGER, col3 CHARACTER(40));
CREATE TABLE
INSERT INTO test1 VALUES (100, 200, 'This is a test');
INSERT 0 1
INSERT INTO test1 VALUES (101, 201, 'Another test');
INSERT 0 1
UPDATE test1 SET col2 = 999 WHERE col1 < 1000;
UPDATE 2
INSERT INTO test1 SELECT * FROM test1;
INSERT 0 2
delete from test1 where col1 >0
DELETE 4
TRUNCATE TABLE test1;
TRUNCATE TABLE
DROP TABLE test1;
DROP TABLE