4.2.2 Options

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 CREATE FUNCTION:
The system treats a line of code through END_PROC; or END_FUNC; as one SQL statement.
For CREATE TYPE:
The system treats a line of code through END_PROC; or END_TYPE; as one SQL statement.
For CREATE TRIGGER:
The system treats a line of code through END_PROC; or END_TRIG; as one 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----+

Directly entering SQL statements:
When pddef is executed, the utility waits for entry of definition SQL statements, which should then be entered. You cannot enter an SQL statement immediately after pddef. Specify a semicolon (;) at the end of each SQL statement.
To terminate pddef, press the CTRL + D keys.
Specifying an input file:
Create an input file containing definition SQL statements. Redirect the standard input to this input file.
Example
pddef <infile

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.