Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Maintenance Considerations for zSeries >

Using odbcsql to Submit SQL Statements

The Siebel Server installation program installs a utility called odbcsql in the SIEBSRVR_ROOT\bin directory of your Siebel Server. Siebel eBusiness Applications use this program to perform operations on the DB2 database whenever these operations are performed from the midtier—that is, from the Siebel Server.

You can use odbcsql to submit SQL statements, for example, to obtain DB2 storage group names for data and indexes that you will be prompted for during the Siebel Database Server installation process.

NOTE:  You can also use any other utilities that allow you to query and return result sets to the client.

As noted earlier, you can also use odbcsql to test your ODBC data source after you install the Siebel Server.

To execute odbcsql

• Navigate to the SIEBSRVR_ROOT\bin directory and enter the following text at a command prompt, as appropriate for your operating system:

  odbcsql /source database_alias /user username /password password

  for example:

  odbcsql /s siebsrvr_siebel /u sadmin /p sadmin

  where:

  /s = the ODBC DSN for the connection.

  /u = the user ID.

  /p = the password.

If odbcsql connection is successful, you can then enter queries against the DB2 catalog tables, for example:

SELECT NAME FROM SYSIBM.SYSSTOGROUP;

This query returns a list of all DB2 storage groups. To exit odbcsql, enter EXIT.

For additional information, enter the following at a command prompt:

odbcsql /help

The odbcsql utility is also useful in troubleshooting postinstallation connectivity problems that come from the ODBC layer of your installation.