M204.2452
Jump to navigation
Jump to search
M204.2452 Index for token field token2 cannot be used in SQL query processing
A Model 204 field is indexed, but this index cannot be used in SQL applications, because the SQL datatype of a column mapped to the field does not match the field datatype.
This message might be produced during SQL query compilation in the following cases:
- Field is ORDERED CHARACTER, but SQL column type is not CHARACTER.
- Field is ORDERED NUMERIC, but SQL column type is CHARACTER.
- Field is KEY STRING, but SQL column type is not CHARACTER.
- Field is KEY or HASH, its datatype is BINARY or FLOAT, but SQL column type is CHARACTER.
- Field is KEY or HASH, its datatype is STRING, but SQL column type is not CHARACTER.
Response: Notify the System Manager.
System manager response: If possible, redefine the field, or alter or recreate the table to change the column datatype, so that there is no datatype mismatch.
Message attributes:
| RETCODEO=0 | Sets online return code |
|---|---|
| RETCODEB=0 | Sets batch (single user) return code |
| CLASS=I | Information class; the message can be suppressed with the X'02' bit setting of the MSGCTL parameter |
| AUDITAD | Writes the message with line type AD to the audit trail |
| NOCOUNT | Does not increment the error count (ERCNT) parameter |