M204.2453

From m204wiki
Revision as of 19:51, 19 March 2018 by JAL (talk | contribs) (add <var>'s)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

M204.2453  SQL request may trigger Table B search in file token and the whole file may be locked

An SQL column is detected, such that it is referenced in the request and its SQL datatype is not consistent with the Model 204 datatype of the underlying Model 204 field. If such a column is used in a retrieval condition of an SQL request, the whole file resource is locked at evaluation time and Table B is searched instead of index. If the file is big, substantial performance degradation results.

This message might be produced during SQL query compilation or evaluation 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, alter or recreate the table to change the column datatype, so that there are no datatype mismatches.

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