|
The middleware (DB2 Connect, etc) that you are using as part of the DB2
Command Center does not support the specification of sort sequences for
dynamic SQL interfaces like OLE DB against a DB2 UDB for iSeries server.
The MSDASQL OLE DB provider essentially allows the OLE DB interface to be
used, but the database requests are passed to an ODBC driver. Most iSeries
customers use the iSeries Access for Windows ODBC driver (formerly Client
Access ODBC driver) which is included with every iSeries Server and does
support Sort Sequences (like your Operations Navigator tests proved).
Sort sequences are supported via this interface because this ODBC driver
connects with the server in a different way than the DB2 UDB middleware you
were testing with.
You can specify the Polish sort sequence on the ODBC Data Source or on the
connection string ("SORTTYPE=3;SORTWEIGHT=0;LANGUAGEID=PLK"). Search the
iSeries Information Center (www.iseries.ibm.com) on ODBC programming.
==================================
MORE INFORMATION ON THIS TOPIC
==================================
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.
|
