Execute SQL Statements on DB2 UDB for Windows from the iSeries

June 22, 2005 Michael Sansoterra

With the necessity of tight integration between platforms pervading many IT shops, I wondered what interoperability exists between the DB2 Universal Database (UDB) on the iSeries and DB2 UDB for Windows. After a little investigation, I was pleased to find that DB2 SQL on the iSeries can be used to execute SQL statements on the Windows DB2 platform as easy as it can on a different iSeries using IBM’s Distributed Relational Database Architecture (DRDA).

For a simple intro to DRDA using two iSeries systems or partitions, see Using DRDA to Execute SQL Statements on Another iSeries. For in-depth info

Case-Insensitive Sorting and Record Selection with Query/400

June 22, 2005 Hey, Ted

Thanks for explaining how to ignore case when sorting and selecting records with SQL. Can you tell me how to do the same with Query/400?

–Ron

Sure. First, here’s a database file that we can query.

LASTNAME    FIRSTNAME 
smith       billy     
Smith       Amos      
SMITH       CHARLEY   
smith       DICK      
Smith       ELMO      
SMITH       dan       
JONES       Andy

The normal sort places lowercase letters before uppercase ones, like this:

LASTNAME    FIRSTNAME 
smith       billy     
smith       DICK      
JONES       Andy      
Smith       Amos      
Smith       ELMO      
SMITH       dan       
SMITH       CHARLEY

From the Define the Query panel, place a 1 (one) beside the Select collating sequence option and press Enter. If your

Turning Off ODBC Journaling Is Not a Good Idea

June 22, 2005 Hey, Joe

After reading your column on “Curing the ODBC Blues,” I came to the same conclusion that you did regarding how to avoid the SQL7008 error: You need to journal your OS/400 files to avoid ODBC update errors. But then someone showed me the ODBC advanced server option in the iSeries Access ODBC driver, where you can set your ODBC drivers’ Commit mode to eliminate the need for journaling files updated by ODBC. This seems like a better solution.

–Brock

Here’s my take on the situation.

By default, IBM sets iSeries Access for Windows ODBC drivers up with a Commit mode