NDB Response Codes › Response Codes

Response Codes

The response codes are listed in ascending order:

0

ERRI=N/A

Database processing completed with no errors.

1

ERRI=N/A

Record with requested key or RID not found (GET/UPD/DEL), OR reposition RID not in scan result list (SEQ RESET).

2

ERRI=N/A

End of file on GET sequential (forward or backward).

3

ERRI=field name

Named field not found for INFO on field name.

4

ERRI=N/A

No records found for supplied SCAN criteria.

5

ERRI=N/A

SCAN terminated-exceeded I/O limit.

6

ERRI=N/A

SCAN terminated-exceeded time limit.

7

ERRI=N/A

SCAN terminated-exceeded storage limit.

8

ERRI=N/A

SCAN terminated-met or exceeded number of records limit.

10-19

ERRI=N/A

Linked &NDBGET/&NDBFMT-extra no find return code as used in the link definition.

20

ERRI=format name

FMT del, format name not found.

21

ERRI=sequence name

SEQ del, sequence not found.

29

ERRI=N/A

Maximum possible Important! code-currently not assigned.

30

ERRI=N/A

Error in request (catch-all). See command/messages.

31

ERRI=N/A

Logic error in request: not signed on to database (NDB). For example, if the NCL procedure is paused and the database stopped/started, then the next call gets this error.

32

ERRI=N/A

Insufficient storage to process request.

33

ERRI=N/A

OPEN request rejected, database is stopping.

34

ERRI=N/A

&NDBOPEN-already open to this NDB.

35

ERRI=N/A

&NDBCLOSE-not open to this NDB.

36

ERRI=N/A

NDB PURGE-nominated NDB not found, could not purge.

37

ERRI=N/A

NDB PURGE-nominated NDB not locked, cannot purge.

38

ERRI=N/A

Load for load module for requested NDB function failed.

39

ERRI=N/A

Requested option not allowed-NDB is in load mode.

40

ERRI=N/A

&NDBOPEN failed by NCLEX01 user exit.

41

ERRI=N/A

This &NDB... verb blocked by &NDBOPEN user exit (NCLEX01) return mask.

51

ERRI=N/A

Database open failure: VFS open for database failed.

Possible causes:

• File not allocated to your product.
• UDBCTL OPEN not done or in error.

52

ERRI=N/A

Database open failure: Specified database name is not a VSAM KSDS.

53

ERRI=N/A

Database open failure: VSAM relative key position (RKP) not 0.

54

ERRI=N/A

Database open failure: VSAM key length too short (that is, fewer than 16) to be a valid NDB database.

55

ERRI=N/A

Database open failure: VSAM data length too short to be a valid NDB database.

56

ERRI=N/A

Database open failure: Read of control record failed.

57

ERRI=N/A

Database open failure: Control record not valid.

58

ERRI=N/A

Database open failure: Unable to get storage to contain control record.

59

ERRI=N/A

Database open failure: Read of transaction control record failed.

60

ERRI=N/A

Database open failure: Transaction control record not valid.

61

ERRI=N/A

Database open failure: Unable to get storage to contain transaction control record.

62

ERRI=N/A

Database open failure: Unable to get storage to contain transaction data record.

63

ERRI=N/A

Database open failure: Error building field name indexes.

64

ERRI=N/A

Database open failure: Error re-applying pending transaction. Probable file full condition.

65

ERRI=N/A

Database open failure: Database flagged as in DEFER status. Probable file corrupt condition, system has failed with database started in DEFER mode.

66

ERRI=N/A

Database open failure: UDB is open by other users.

67

ERRI=N/A

UDB is open INPUT and NDB START or &NDBOPEN is not for INPUT only mode.

68

ERRI=N/A

Domain ID on NDB control record and this system mismatch, and FORCE not on NDB START. NDB is not started. Important!-it might be currently open in another system.

69

ERRI=N/A

NDB version in this NDB control record not supported.

70

ERRI=N/A

This NDB is open under another file ID on this system (VSAM timestamp match).

71

ERRI=N/A

Request not allowed on active database. For example, NDB CREATE, NDB RESET, NDB ALTER, or NDB UNLOAD.

72

ERRI=N/A

User ID required for request. Internal failure, should never occur with NDB command.

73

ERRI=sequence name

Specified sequence name not defined.

74

ERRI=sequence name

Sequence name required or already defined.

75

ERRI=N/A

Free-format text had an invalid token:

• Too long
• Unmatched quotes

76

ERRI=N/A

Logic error-not signed on to database (NDB). For example, if NCL proc is paused, and DB stopped/started, then next call will get this error.

77

ERRI=N/A

This user ID has an asynchronous request running. Internal failure; should never occur with NDB command or &NDB statements.

78

ERRI=N/A

Request internally canceled.

79

ERRI=N/A

OPEN EXCLUSIVE-other users on database.

80

ERRI=N/A

OPEN-database locked by an exclusive user.

81

ERRI=field name if relevant

Add, update, or delete field, an error in the field list syntax, and so on.

82

ERRI=N/A

Add, update, or delete field, an internal error in the field index.

83

ERRI=field name

Value for named field is bad, not recognizable as valid data.

84

ERRI=field name

Value for named field is too long.

85

ERRI=field name

Value for named numeric field is not numeric, or outside range:

-2,147,483,648 : 2,147,483,647.

86

ERRI=field name

Value for named hexadecimal field is not a valid hexadecimal string, or is an odd number of characters.

87

ERRI=field name

Value for named DATE or CDATE field is not valid.

88

ERRI=field name

Field name is not a valid floating point number.

89

ERRI=field name

Supplied value is not a valid hexadecimal number.

90

ERRI=field name

Value for named time field is not a valid time, in the format:

HHMMSS or HHMMSS.TTTTTT.

92

ERRI=N/A

Operation not allowed. NDB or user open in input-only mode.

93

ERRI=field name

Field update request-could not read field record from NDB.

94

ERRI=field name

Supplied value is not a valid timestamp, in the format:

YYYYMMDDHHMMSS.TTTTTT.

101

ERRI=token in error

ADD or UPD, field=value list syntax error.

102

ERRI=field name

ADD or UPD, required field not provided.

103

ERRI=field name

ADD record, sequence key value already on database (that is, not unique).

104

ERRI=field name

ADD/UPD record, KEY=UNIQUE field value not unique.

105

ERRI=field name

UPD record, UPDATE=NO value change for field.

106

ERRI=format name

Format specified on an ADD or UPD does not exist.

107

ERRI=format name

Format specified on an ADD or UPD exists but is an INPUT format and cannot be used for output.

111

ERRI=format name

FMT add, format name '*' is invalid.

112

ERRI=format name

FMT add, format name already exists.

114

ERRI=token in error

FMT/GET, format list syntax error.

115

ERRI=field name

FMT/GET, field name not defined in database.

116

ERRI=format name

Format specified on a GET exists but is an OUTPUT format and cannot be used for input.

117

ERRI=field name

You have referenced an NDB field twice in an OUTPUT format definition.

118

ERRI=field name

You have used an NCL keyword name in an OUTPUT format, but the keyword is not an NCL system variable name.

121

ERRI=format name

GET, supplied format name not defined.

122

ERRI=field name

GET by key, key field not defined on database.

123

ERRI=field name

GET by key, field not keyed.

124

ERRI=sequence name

GET by sequence, sequence ID not defined.

125

ERRI=sequence name

GET by sequence, key field for sequence has been deleted (by &NDBDEF DELETE).

126

ERRI=sequence name

GET by sequence, skip=0 specified and not currently positioned.

127

ERRI=sequence name

GET by sequence, skip=0 specified and currently at EOF (front or back).

128

ERRI=field name

GET by key field, GENERIC= is invalid for this field format. Generic access is only allowed for character and HEX fields.

130

ERRI=field name

&NDBGET histogram (KEY=) on sequence key not supported.

131

ERRI=sequence name

SEQ DEF-invalid sequence name.

132

ERRI=sequence name

SEQ DEF, sequence name already exists.

133

ERRI=N/A

SEQ DEF, from or to RID invalid.

134

ERRI=sequence name

SEQ DEF, field name not found or is not a key.

135

ERRI=N/A

SEQ DEF, from or to values not valid.

136

ERRI=field name

SEQ DEF, generic invalid with field format.

137

ERRI=N/A

SEQ DEF, invalid null value for GENERIC=.

139

ERRI=sequence name

SEQ RESET, sequence not found.

140

ERRI=invalid data value

SEQ RESET, REPOS= value invalid or null.

141

ERRI=N/A

SEQ RESET, REPOS= not valid on a scan sequence that is not sorted, or, while sorted, the primary sort field was substringed.

142

ERRI=sequence name

SEQ RESET, REPOS by RID only valid for a SCAN sequence.

143

ERRI=N/A

&NDBSEQ histogram (KEY=) on sequence key not supported.

144

ERRI=sequence name

RELPOS sequence is not a sequence constructed by &NDBSCAN.

151

ERRI=N/A

INFO by field number, number lt 1 or gt number fields in database.

161

ERRI=sequence name

SCAN sequence ID is already defined.

162

ERRI=sequence name

SCAN sequence ID is currently in use, by an active scan for this user.

163

ERRI=field name

SCAN SORT= field name not defined on database.

183

ERRI=N/A

SCAN syntax error in scan request.

191.

ERRI=N/A

Unload failed. Accompanying messages will indicate the cause of the failure

193

ERRI=N/A

NDB ALTER failed.

237

ERRI=N/A

File integrity error, get if continuation DBDR failed. Database possibly corrupted. Contact Technical Support.

238

ERRI=field name

File integrity error, get XFF if DBKR failed. Database possibly corrupted. Contact Technical Support.

239

ERRI=field name

File integrity error, get KGE if DBKR failed. Database possibly corrupted. Contact Technical Support.

240

ERRI=N/A

VSAM I/O Error. See log for more information.

241

ERRI=N/A

Request not processed-invalid request code (internal error), should never occur with NCL (&NDB) or NDB command.

242

ERRI=N/A

Request not processed-RPL busy flag set (internal error), should never occur with NCL (&NDB) or NDB command.

243

ERRI=N/A

Request not processed-insufficient storage to queue request to database handler. Try again.

244

ERRI=N/A

Request not processed-required text parameter not provided (internal error). Should never occur with NCL (&NDB) or NDB command.

245

ERRI=N/A

Request not processed-Database not started.

246

ERRI=N/A

Request not processed-required VAL1 parameter not provided (internal error). Should never occur with NCL (&NDB) or NDB command.

247

ERRI=N/A

Request not processed-required VAL2 parameter not provided (internal error). Should never occur with NCL (&NDB) or NDB command.

248

ERRI=N/A

Request not processed-database not LOCKED. Only applicable to NDB START UNLOCK command.

250

ERRI=N/A

Request not processed-database is LOCKED or STOPPING.

251

ERRI=N/A

Request not processed-long running command currently in progress. For example, NDB UNLOAD.

252

ERRI=abend code

This return code indicates that an NDB operation was terminated due to a logical abend caused by a possible NDB corruption. The log will contain useful debugging information.

For update requests, the NDB will be stopped and locked. For read/scan requests, the request is terminated but the NDB will continue to process other requests.

254

ERRI=N/A

Request not processed-feature not present, or your product is shutting down.