MSIR.0259 SYBMSG(41101,15,1) Ambiguous column name (colname).: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
(Automatically generated page update)
Line 1: Line 1:
This message indicates that the [http://m204wiki.rocketsoftware.com/images/e/e4/JsdsrNew.pdf Janus Specialty Data Store] received a SQL request sent by the client (probably an Adaptive Server) that contained SQL with an ambiguous columns name, that is a column name that occurs in more than one of the tables in the request and does not contain a table name prefix. If the SQL was sent by an Adaptive Server or Omni Connect Gateway (rather than a direct client connection) this is indicative of a bug in either the Adaptive Server or Omni Connect Gateway or in <var class="product">Janus Specialty Data Store</var>. Contact [[Contacting Rocket Software Technical Support|Technical Support]].
This message indicates that the [http://m204wiki.rocketsoftware.com/images/e/e4/JsdsrNew.pdf Janus Specialty Data Store] received a SQL request sent by the client (probably an Adaptive Server) that contained SQL with an ambiguous columns name, that is a column name that occurs in more than one of the tables in the request and does not contain a table name prefix. If the SQL was sent by an Adaptive Server or Omni Connect Gateway (rather than a direct client connection) this is indicative of a bug in either the Adaptive Server or Omni Connect Gateway or in <var class="product">Janus Specialty Data Store</var>. Contact [[Contacting Rocket Software Technical Support|Technical Support]].


{{Template:MSIR.0259 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 the Janus Specialty Data Store received a SQL request sent by the client (probably an Adaptive Server) that contained SQL with an ambiguous columns name, that is a column name that occurs in more than one of the tables in the request and does not contain a table name prefix. If the SQL was sent by an Adaptive Server or Omni Connect Gateway (rather than a direct client connection) this is indicative of a bug in either the Adaptive Server or Omni Connect Gateway or in Janus Specialty Data Store. Contact Technical Support.


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
NOTERMDoes not display the message on the user's terminal

Back to list of messages