Bookshelf Home | Contents | Index | PDF |
Implementing Siebel Business Applications on DB2 for z/OS > Maintaining Siebel Business Applications on DB2 for z/OS > Using the odbcsql Utility to Submit SQL StatementsThe Siebel Server installation program installs the odbcsql utility in the You can use odbcsql to submit SQL statements, for example, to obtain the DB2 storage group names for data and indexes which you have to specify during the Siebel database installation process. NOTE: You can also use other utilities that allow you to query and return result sets to the client. You can also use odbcsql to test your ODBC data source after you install the Siebel Server.
If the odbcsql connection is successful, you can enter queries against the DB2 catalog tables. For example, the following query returns a list of all DB2 storage groups: SELECT NAME FROM SYSIBM.SYSSTOGROUP; To exit odbcsql, enter EXIT. For additional information on the utility, enter the following at a command prompt: The odbcsql utility is also useful in troubleshooting postinstallation connectivity problems that arise in the ODBC layer of your installation. |
Implementing Siebel Business Applications on DB2 for z/OS | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |