Product specifications

The data access driver does not allow ordering columns by index in SQL statements. Only ORDER BY
with column names is a valid clause. The ORDER_BY_SUPPORTS_COLUMN_INDEX parameter is set to
NO in the jco.prm file.
Related Topics
• ORDER_BY_SUPPORTS_COLUMN_INDEX
6.2.2 Access to InfoSets and SAP Queries
About InfoSets and SAP Queries
In the SAP ERP system, InfoSets are created within either a local work area or a global work area.
Objects within the local work area are only accessed by its SAP ERP system client, while objects of
the global work area can be accessed by all clients. A SAP Query is created in a user group and belongs
to it.
Note:
For more information about work areas and user groups, refer to your SAP ERP documentation.
Object mapping
The data access driver exposes InfoSets and SAP Queries as tables to the information design tool.
InfoSets and SAP Queries are made of a series of fields, which are mapped to table columns. Fields
are used in SELECT statements.
At driver level, work areas are mapped to qualifiers and user groups are mapped to owners. User groups
of a work area are then placed beneath a qualifier that represents this work area.
InfoSets of a work area are placed beneath a qualifier that represents this work area and beneath a
fictive owner called INFOSET. SAP Queries of a work area are placed beneath the qualifier that
represents this work area. SAP Queries of a user group are placed beneath the owner that represents
this user group.
The organization of InfoSets and SAP Queries in a work area is depicted in the figure below:
2012-03-1569
Data access driver reference