M204.2452

From m204wiki
Revision as of 03:46, 14 March 2018 by DmeWiccan (talk | contribs) (Automatically generated page update)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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, either redefine the field, or alter or recreate the table to change the column datatype, so that there is no datatype mismatch.


Message attributes:

RETCODEO=0Sets online return code
RETCODEB=0Sets batch (single user) return code
CLASS=IInformation class; the message can be suppressed with the X'02' bit setting of the MSGCTL parameter
AUDITADWrites the message with line type AD to the audit trail
NOCOUNTDoes not increment the error count (ERCNT) parameter

Back to list of messages