SAP Knowledge Base Article - Preview

2418535 - Error 107 "column prefix does not match" for FOR XML query

Symptom

ASE raises error 107 when a correlated subquery is used in a query with a FOR XML clause

Example:
Msg 107, Level 15, State 1:
Server 'sybase', Line 12:
The column prefix 't1' does not match with a table name or alias name used in
the query. Either the table is not specified in the FROM clause or it has a
correlation name which must be used instead.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)  all versions
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE) all versions

 

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Keywords

Sybase, ASEServer, SAPASE, CR805078, CR#805078, 805078 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.