MSIR.0254 Invalid COLUMN numbers for TABLE (tabname): Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
(Automatically generated page update)
Line 5: Line 5:
<p class="note"><b>Note:</b> The column numbers don't have to appear in sequential order in the file, since the <var class="product">Janus Specialty Data Store</var> sorts the records by COL_NUM before processing them. It is only essential that, once sorted, the COL_NUM values go from 1 to the number of columns. </p>
<p class="note"><b>Note:</b> The column numbers don't have to appear in sequential order in the file, since the <var class="product">Janus Specialty Data Store</var> sorts the records by COL_NUM before processing them. It is only essential that, once sorted, the COL_NUM values go from 1 to the number of columns. </p>


{{Template:MSIR.0254 footer}}
[[Category:Sirius Mods messages]] [[Category:MSIR.0200 - MSIR.0399]]
[[Category:Sirius Mods messages]] [[Category:MSIR.0200 - MSIR.0399]]

Revision as of 21:34, 7 July 2016

This message indicates that a table was defined in the JANCAT file for a Janus Specialty Data Store port, but the column number field (COL_NUM) in the column descriptor records (RECTYPE=C) for that table did not go from 1 to the number of columns in the table. While the port is started (or reloaded) in spite of the error, the indicated table is marked as invalid and is not usable after this error.

This error is indicative of an error in an ad hoc or user application run against the JANCAT file or a bug in the JANCAT application. In the former case (and maybe even the latter) correct the data in the JANCAT file with another ad hoc or restore the JANCAT file to the state it was in before the bad data was added to the file. In the latter case, call Technical Support.

Note: The column numbers don't have to appear in sequential order in the file, since the Janus Specialty Data Store sorts the records by COL_NUM before processing them. It is only essential that, once sorted, the COL_NUM values go from 1 to the number of columns.


Message attributes:

RETCODEO=0Sets online return code
RETCODEB=4Sets batch (single user) return code
CLASS=EError class; the message can be suppressed with the X'04' bit setting of the MSGCTL parameter
AUDITERWrites the message with line type ER to the audit trail
COUNTIncrements the error count (ERCNT) parameter

Back to list of messages