Abend S013

Could be one of the following reasons:

->Conflicting or incomplete parameters in DCB, such as BLKSIZE not a multiple of LRECL, or
missing SYSIN DD;
->Tried to create a PDS without allocating directory blocks;
->Member name specified in DD not found;
->no directory allocation sub parameter in DD;
->Open output dataset as input;
->Track overflow or updating attempted, but not supported by the OS.
->May be a record length or OPEN statement error.

SQLCODE = -204

ERROR: is an undefined name

SQLCODE = -679

Error: The object cannot be created because a drop is pending on the object. This occurred

when a create index statement is issued immediately after a drop index statement.

Drop index
create index on
(col1 Asc, Col2 Asc);
Commit work;

SQL : Error handling : WHENEVER stmt

The WHENEVER statment specifies the action to be taken when a specified exception condition occurs
This stmt can only be empedded in an application program. It is not an exeuctable stmt. It must not be specified in Java or REXX.

Syntax:
WHENEVER <>

Default :
WHENEVER <> CONTINUE.

PLI: ENVIRONMENT(CTLASA)

CTLASA option specifies American National Standard Vertical carriage positioning characters or American National standard Pocket selection characters (Level 1). The CTL360 option specifies IBm machine-code control characters.
The American National Standard control characters:
(blank) Space 1 line before printing
0 Space 2 lines before printing
- Space 3 lines before printing
+ Suppress space before printing
1 Skip to channel 1
2 Skip to channel 2
.
.
.
9 Skip to channel 9
A Skip to channel 10
B Skip to channel 11
C skip to channel 12
V select stacker 1
W select stacker 2

SQLCODE = -401 SQLSTATE= 42818

THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE