SQLCODE = -181 SQLSTATE=22007

THE STRING REPRESENTATION OF A DATETIME VALUE IS NOT A VALID DATETIME VALUE

Bad data in Date/Time/Timestamp
Value for DATE, TIME, TIMESTAMP is invalid

Ex: 0000-00-00

SQLCODE = -180 SQLSTATE= 22007

Bad data in Date/time/timestamp
String representation of DATE, TIME, TIMESTAMP is invalid.

SQLCODE = -117

The number of values you are trying to INSERT does not match the number of
columns

SQLCODE = -102

String constant is too long

DB2: How does DB2 store NULL physically?

as an extra-byte prefix to the column value.
The NULL prefix is Hex '00' if value other than NULL is present in the column.
The NULL prefix is Hex 'FF' if the column has NULL value.

Common abends

S322
Timed out, try changing job class.

S806
Load module not found. Check library specified in the joblib.

S913
Insufficient authority. Check if you have required access to dataset.

S0C4
Storage related problem. Check your linkage section table definition and FD section