Specifies that END_FUNC; (for CREATE FUNCTION), END_TYPE; (for CREATE TYPE), or END_TRIG (for CREATE TRIGGER) is to be added to demarcate the end of the SQL statement.
For the handling of continuation lines for SQL statements, see 4.3 Handling of continuation lines.
Specifies that an input wait prompt is to be displayed when a definition SQL is entered directly.
There are two different prompts that are displayed according to the input status:
COMMAND?: Indicates a prompt for a normal entry.
NEXT?: Indicates a prompt for a continuation line of an SQL statement.
The following shows examples:
pddef -s
COMMAND ? +----2----+----3----+----4----+----5----+----6----+----7----+
CREATE TABLE T1 (
NEXT ? +----2----+----3----+----4----+----5----+----6----+----7----+
C1 INT,
NEXT ? +----2----+----3----+----4----+----5----+----6----+----7----+
C2 CHAR(64)
NEXT ? +----2----+----3----+----4----+----5----+----6----+----7----+
);
KFPA12000-I Processing of SQL completed
COMMAND ? +----2----+----3----+----4----+----5----+----6----+----7----+
Specifies that the pddef return code is to be set to 4 if the SQLCODE for any SQL statement that executes is a negative value (including abnormal termination during HiRDB connection). You specify this option when you wish to detect errors in SQL statements during execution of pddef.