CALL DML status codes

DML optional entry error:

C00	The specified function code is not correct.
C01	The specified function option is not allowed with the specified function code.
C02	The specified secondary option is not allowed with the specified combination of function code and function option, or it contains syntax errors.

Record name error:

C03	The specified record name is not present in the relevant subschema or is not unique.
C04	A mandatory record name has not been specified.

Set name error:

C05	The specified set name is not present in the current subschema or is not unique.
C06	Syntax error in the set name list (too many set names; incorrect separators or terminators for set names; set name occurs more than once)

Realm name error:

C07	The specified realm name is not present in the current subschema or is not unique.
C08	Syntax error in the realm name list (too many realm names; incorrect separators or terminators for realm names; realm name occurs more than once)

Item name error:

C09	The specified item name is not present in the relevant record of the current subschema or is not unique.
C10	Syntax error in the item name list (too many item names; incorrect separators or terminators for item names)

Result of IF statement:

C11	The IF condition is not satisfied. C11 should not be regarded as an error code but rather as the result of the DML statement IF; the code is 000 if the condition is satisfied.

Search expression error:

C20	The search expression contains too many search conditions.
C21	A NXT search condition after an OR operator is not allowed.
C22	The separator before and after an item name or relational operator in a search condition must always be a space.
C23	The number of parentheses in a NXT search condition must be equal to zero.
C24	The mask for a search condition may only consist of the characters 0 and 1 and must be terminated with a space.
C25	A NXT search condition may not be enclosed in parentheses.
C26	The length of the mask for a search condition must be the same as the length of the item.
C27	NXT search conditions may only be located at the end of a search expression.
C28	A search condition is not terminated with _OR_, _AN_ or _END.
C29	The length of a value in a search condition is incorrect.
C30	The number of right-hand parentheses in a search condition is not numeric.
C32	There are more left-hand than right-hand parentheses in a search expression.
C33	The NEQ relation is not allowed in a NXT search expression.
C34	The relational operator in a search condition is not correct.
C35	The number of left-hand parentheses in a search condition is not numeric.
C37	Too many right-hand parentheses have been specified in a search condition.
C38	The relational operator in a search condition is not followed by a space.
C39	The item name of a search condition is not present in the current subschema or is not unique.
C40	The item type of a search condition is printable numeric but the associated comparison value is not.
C41	The item type of a search condition is packed decimal but the associated comparison value is not.
C42	Search conditions are not allowed for this item type.

Retaining entry error:

C61	The specified retaining option (special parameter 1) is not correct.
C62	A specified retaining set name (special parameter 1) is not present in the current subschema or is not unique.
C63	Syntax error in the retaining set name list (too many set names; incorrect separators or terminators for set names; set name occurs more than once).

Other errors:

C66	The SSITAB module of the subschema cannot be identified, or the specified subschema name matches only the first 6 characters of the subschema name given in the SSITAB module, not its entire length. Execute BCALLSI run.
C72	The integer indicating the record position in a FIND4/FTCH4 call must not be zero.

Specific FIND7A/FTCH7A errors:

C74	The specified name of the limited set is not present in the current subschema or is not unique.
C75	The specified name of the result set is not present in the current subschema or is not unique.

Specific LOOKC errors:

C80	The number of LOOKC blocks must be between 1 and 255 (inclusive).

User communication errors:

C90	A work buffer of the size needed by the UDSCDML converter module cannot be made available. If necessary, the communication pool must be enlarged (see the manual “Database Operation“).
C91	The error exit DSCEXT was not defined.
C94	The converter module UDSCDML is not present.
C95	The SSITAB module generated by BCALLSI is not present or could not be loaded into memory (possibly due to a lack of memory space).
C98	An attempt is made to execute ACCPTL, FIND1L, FTCH1L, STORE1L or STORE2L with an SSITAB module which was generated before UDS/SQL V2.0 or using a "FORM IS OLD" subschema. To execute the specified functions, you require an SSITAB module of a version >= V2.0 without "FORM IS OLD".
C99	The SSITAB module is invalid or incompatible with the version of the CALL DML translation routine.

Validity check on DML statements on the basis of the subschema structure:

P01	A FIND2/FTCH2 statement with optional parameter ANY... is only allowed if LOCATION MODE IS CALC is specified and all keys of the record type are present in the subschema.
P02	A FIND2/FTCH2 statement with optional parameter DUPLIC is only allowed if LOCATION MODE IS CALC and DUPLICATES ARE ALLOWED are specified and all keys of the record type are present in the subschema.
P03	Duplicates are not allowed for the current FIND3/FTCH3 statement.
P04	A FIND7A/FTCH7A statement is only allowed if the referenced record type is a member of the specified set.
P05	A FIND7A/FTCH7A statement for SET OCCURRENCE IS THRU LOCATION MODE OF OWNER is: only allowed in connection with LOCATION MODE IS DIRECT if the item involved is present in the subschema. only allowed in connection with LOCATION MODE IS CALC if all keys of the record type are present in the subschema.
P06	A FIND4/FTCH4 or FIND5/FTCH5 statement is only allowed if the specified record type is a member of the specified set.
P07	A FIND4/FTCH4 or FIND5/FTCH5 statement is only allowed if the specified record type is permissible in the specified realm.
P08	A FIND6/FTCH6 statement is only allowed if the set involved is not a SYSTEM set.
P09	The form of storage specified for the set does not allow CONNEC or DISCON statements, or, in the case of DISCON ALLFRM, the set specified is not a dynamic set.
P10	In the set name list of a CONNEC or DISCON statement, only sets which have the same record type as member are allowed.
P11	For a CONNEC or DISCON statement, the Current of Run Unit must belong to the member record type of the specified set.
P12	For a CONNEC TO-ALL statement, the subschema must contain at least one set with the referenced record type which is not MANDATORY AUTOMATIC. For a DISCON FRMALL statement, the referenced record type must be OPTIONAL member in at least one set of the subschema.
P13	The specified MODIF1/2 statement is not allowed.
P14	The specified STORE1/2 statement is not allowed.
P15	The specified ERASEC statement is not allowed.
P16	The set specified in the RESULT and/or LIMITED clause is not a dynamic set.