Some common mainframe host messages are:
CLI026 |
HSISPB unavailable. Failed to issue GLOBAL TXTLIB CLI. (CLI TXTLIB found on the TERADATA disk contains HSISPB). |
CLI036 |
Invalid TDPID in logon text string. The TDP ID preceding the logon string does not conform to the rules for a valid TDP ID. |
CLI040 |
Invalid logon string. The logon string passed to DBCLGN is invalid. |
CLI282 |
Requested TDP not available. The TDP ID specified is valid but the requested TDP is not active. |
CLI426 |
TDP unavailable -- connect failed -- TDP not logged on. The TDP is unavailable because the TDP machine is not logged on. |
CLI521 |
Failure due to security violation. An attempt to log on to Teradata was made and an invalid logon id was given. |
Some general return codes, which may be tested with the Dialogue Manager &RETCODE variable or the MODIFY FOCERROR variable, include:
0 |
No error. Successful execution. |
2978 |
Table to be created already exists. |
2980 |
Duplicate primary key. An insert was attempted using a unique primary key, a row with the key value specified was found already to exist. |
3510 |
Too many END TRANSACTION statements. You issued an END TRANSACTION statement that does not correspond to a BEGIN TRANSACTION statement. |
3523 |
User does not have specified operation access to object. (For example, you tried to perform an action within Teradata for which you are not authorized.) |
3604 |
Cannot place a null value in a NOT NULL field. |
3807 |
Table/view table name does not exist. You referenced a table or view that does not exist. |
| Information Builders |