091

5B

Y

Y

CBS SET DEFINITION NOT
FOUND

A SELNR or SELSM command was issued. The prerequisite SELFR command returns a
system-generated set number in
the Request Area. A set definition with this number cannot be found. You might have altered the set number in the Request Area, or
used a different Request Area with
the SELFR command, or previously released the set by issuing a SELPR command.

Investigate these possibilities and take appropriate action.

092

5C

S

N

IMPROPER RELATION
OPERATOR IN S-LINE

An invalid relational operator was found in the SELFR command's Request Qualification Area (RQA)
in the selection section. The entry
in error can be found in the
Compound Boolean Selection
feedback field of the Request Area.

For a list of valid relational operators, see the CA Datacom/DB Programming Guide.

093

5D

S

N

IMPROPER FIELD TO ELEMENT RELATION

The dataview definition for this field extends beyond the element as defined in the Directory (CXX).

Check for synchronicity of dataview and Directory.

094

5E

S

N

SORT ORDER NOT 'A' OR 'D'

The order code of an entry in the order-by section (section type K)
of the Request Qualification Area
(RQA) was not an A (ascending)
or a D (descending). The entry
in error can be found in the
Compound Boolean Selection
feedback field of the Request Area.

Use the appropriate entry.

095

5F

S

N

IMPROPER ORDERED-BY FIELD 'CLASS'

The data type of an entry in the order-by section (section type K)
of the Request Qualification Area (RQA) is invalid. The entry in error
is in the Compound Boolean
Selection feedback field of the
Request Area.

For a list of valid data types, see the information about the order-by section in the CA Datacom/DB Programming Guide.

096

60

S

N

IMPROPER CLASS IN
CONDITION- OPERAND 1

The scope field of an entry in the Request Qualification Area's
selection section (section type S)
is invalid.

For a list of valid values, see the information about the predicate subject in the CA Datacom/DB Programming Guide.

097

61

S

N

IMPROPER CLASS IN
CONDITION- OPERAND 2

The type field of an entry in the Request Qualification Area's
selection section (section type S)
is invalid.

For a list of valid values, see the information about the predicate object in the CA Datacom/DB Programming Guide.

098

62

Y

N

IMPROPER ZONED FIELD, RQA LENGTH

The Request Qualification Area
length is not a valid unsigned
zoned decimal number.

Correct the Request Qualification Area's length field.

099

63

S

N

DUPLICATE 'S' SECTION

More than one selection section (section type S) was found in the Request Qualification Area.

Combine all selection sections into one section.

100

64

S

N

DUPLICATE 'K' SECTION

More than one order-by section (section type K) was found in the Request Qualification Area.

Combine all order-by sections into one section.

101

65

S

N

INVALID SECTION CODE IN REQUEST QUALIFICATION AREA

For a list of valid sections, see the CA Datacom/DB Programming Guide.

102

66

N

N

ONE OR MORE CA DATACOM/DB RECORDS HAVE DATA ERRORS

This can occur when a zoned or packed decimal field is used for selection (CA Ideal WHERE
clause).

When a temporary index is built,
this return code indicates that one
or more of the records selected had illegal data format (would have
caused a program check, data exception). These records have
been included in the set and are returned with a return code of 91 (internal code 103) when requested
by a SELNR command.

The records in error can either be displayed by the application program, bypassed, or the entire set rejected.

103

67

N

N

THIS CA DATACOM/DB RECORD HAS DATA ERRORS

The record returned contains a
packed or zoned decimal field that
is invalid.

The records in error can either be displayed by the application program, bypassed, or the entire set rejected.

104

68

S

N

IMPROPER LOGICAL OPERATOR
IN S-LINE

The Request Qualification Area's selection section (section type S) contains an invalid logical operator. The entry in error is in the
Compound Boolean Selection
feedback field of the Request Area.

For a list of valid values, see the CA Datacom/DB Programming Guide.

105

69

Y

N

CBS INTERNAL ERROR

An invalid condition has been detected. The exact condition is indicated in Request Area bytes
57-60 as the offset in the program where the error occurred.

Contact CA Support and provide them with the value contained in these bytes. For information about contacting CA Support, see Troubleshooting.

106

6A

S

N

IMPROPER ZONED FIELD IN QUALIFICATION AREA

The Request Qualification Area has a zoned decimal field that does not contain a valid zoned decimal number.

For a definition of the Request Qualification Area's zoned decimal fields, see the CA Datacom/DB Programming Guide.

107

6B

Y

N

IMPROPER CBS COMMAND

An invalid command beginning
with SEL was used. Valid SELxx commands follow:

SELCN SELFR
SELNR SELPR
SELSM SELST

Replace the invalid command with a valid command.

108

6C

Y

N

IMPROPER PACKED LITERAL
IN QUALIFICATION AREA

The Request Qualification Area has a field defined as packed that does not contain valid packed data.

For more information, see the CA Datacom/DB Programming Guide.

109

6D

Y

N

IMPROPER OPERAND
LENGTHS

The operand length does not
equal the specified length if
binary or floating-point, or the operand length exceeds the limit
of 16 for packed or 31 for zoned.
The Request Qualification Area's selection section (section type S) entry in error is in the Compound Boolean Selection feedback field
of the Request Area.

Correct the improper lengths.

110

6E

Y

N

UNDEFINED ELEMENT

For a CA Ideal program, this
usually occurs when the dataview definition has changed in CA Datacom Datadictionary but
has not been CATALOGed in
CA Ideal, or when the Directory
(CXX) has not been updated.

Use an element name defined in the Directory. To obtain a list of elements defined in the Directory, obtain a full report of the Directory by executing the DBUTLTY REPORT AREA=CXX function.

111

6F

Y

N

DBRW OVERFLOW

This occurs most frequently when a table with a large number of keys is used with a large number of
selection predicates joined by OR.
(CA Ideal example: WHERE
FLDA = '__' OR FLDB = '__' OR ... ).

Increase the value assigned to the size parameter of the MUF startup option TASKS and restart the MUF.

112

70

Y

N

SELECT ENDED, EXCESSIVE FAILURES

During the execution of the SELFR command, the number of data
records rejected exceeded the limit
set by the MUF startup option CBS optional parameter maxstio.

Choose a different selection (CA Ideal WHERE clause) that locates records more directly, builds a new key to access the records directly, or increases the limit set in the MUF startup option CBS and restarts the Multi-User Facility.

113

71

Y

N

SELECT ENDED, MAX RECORDS
IN SET

The number of allowable entries in
the temporary index specified in the MUF startup option CBS optional parameter maxsten was exceeded.
CA Datacom/DB is deleting the temporary index.

Use a different selection and ordering criteria (CA Ideal WHERE and ORDERED BY clauses) to eliminate building a temporary index, build a new key to satisfy the ordering criteria, or increase the value for the number of entries in the MUF startup option CBS and restart the Multi-User Facility.

119

77

Y

N

REQUEST ENDED, EXCESSIVE
I/O

The I/O limit set in the CBSIO= parameter in the User Requirements Table DBURSTR macro, the plan or precompiler option, or the SQL plan option has been exceeded.

Increase the I/O limit by increasing the value of the CBSIO= parameter. Valid entries for this parameter are 0—524280. The default value is zero. With CBSIO=0 the number of I/Os are unlimited.

120

78

Y

N

IMPROPER DATA TYPE

The data type field is not B, C, D, E, F, N, P, or Z.

Correct the data type field using the appropriate code to represent the type of data:

B

Binary

C

Character

D

Double precision floating-point

E

Single precision floating-point

F

Packed decimal with any valid sign

N

Zoned decimal with any high-order nibble

P

Packed decimal with preferred signs

Z

Zoned decimal with F high-order nibble

121

79

Y

N

IMPROPER SIGN FIELD

The sign field is not Y, N, P, or

blank.

Correct the sign field using the appropriate code:

N or Blank

Unsigned

P

Signed, positive numeric values

Y

Signed

123

7B

Y

N

INVALID STRING OPERATOR

The type comparison field is S,
but the string operator field is
not SP, SA, or IG.

Replace the invalid relational operator with one of the following:

IG

Ignore

SA

String absent

SP

String present

124

7C

Y

N

SIGN INVALID WITH
CHARACTER DATA

The sign code must be blank or N
with character data.

Correct the sign code to indicate unsigned.

125

7D

Y

N

SCOPE FIELD NOT R OR E

Indicate the scope in the selection section's predicate subject with one of the following codes:

E

Element

R

Record (valid with string operators only)

129

81

Y

N

UNDEFINED PARAMETER NAME

The parameter name field is not
CNT, FST, IIO, INF, INR, UNQ, or
UPD.

Correct the parameter name field. Valid parameters include the following:

CNTx

Count parameter

FST

Partial set parameter

IIO

Interrupt start I/O's

INF

Interrupt records rejected

INR

Interrupt records accepted

UPD

Update intent parameter

UNQ

Unique values parameter

130

82

Y

N

ERROR IN PARAMETER SPECIFICATION

The parameter specification
contained an error.

Use a valid value and rerun. For valid values, see the CA Datacom/DB Programming Guide.

137

89

N

N

ORDER-BY LENGTH TOO LONG

The combined length of all fields
in the Request Qualification Area order-by section (section type K)
is greater than 160 bytes.

Either correct the length of the order-by fields, or remove some of the fields such that the combined length is less than 161 bytes.