MSIR.0259 SYBMSG(41101,15,1) Ambiguous column name (colname).: Difference between revisions
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=0 | Sets online return code |
|---|---|
| RETCODEB=4 | Sets batch (single user) return code |
| CLASS=E | Error class; the message can be suppressed with the X'04' bit setting of the MSGCTL parameter |
| AUDITER | Writes the message with line type ER to the audit trail |
| COUNT | Increments the error count (ERCNT) parameter |
| NOTERM | Does not display the message on the user's terminal |