Bookshelf Home | Contents | Index | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Maintenance Considerations for zSeries > Using odbcsql to Submit SQL StatementsThe Siebel Server installation program installs a utility called odbcsql in the 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.
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: The odbcsql utility is also useful in troubleshooting postinstallation connectivity problems that come from the ODBC layer of your installation. |
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 |