DBISQLC.exe

What is DBISQLC.exe ?
DBISQLC.exe is an Interactive SQL Anywhere program, located in the Siebel Tools or Siebel Web Client folder, helpful in analyzing the SQL statements. The statistics pane provides the analysis information for the SQL's.

How Do I Login to DBISQLC ?
For Siebel Application Versions 7.0.x and 7.5.x
1. Launch dbisqlc.exe from the %SIEBEL_CLIENT_ROOT%\bin directory to bring up the Connect to SQL Anywhere dialog window. On the Login tab fill out the following fields. NOTE: The values for the User ID and Password have to be in upper case
User ID        -    DBA
Password     -    SQL
Database     -    C:\%Siebel_Client%\local\sse_data.dbf

2. After clicking on the OK button, the user will connect to the local database. A message "Connected to database" should appear in the Statistics sub-window.

For Siebel Application Versions 7.7.x or 8.0 or higher
NOTE: The values for the User ID and Password have to be in upper case
User ID       -    DBA
Password    -    ENTERPRISE_NAME
Database    -    C:\%Siebel_Client%\local\sse_data.dbf
If the ENTERPRISE_NAME is less than 8 characters, then the password is appended with 1234.


How Do I run a query against SQL Anywhere ?

1. In the Command sub-window, type the query you want to perform. Ensure that you put the table owner name in front of the Siebel table names. Here is an example:

SELECT NAME, LOC
FROM SIEBEL.S_ORG_EXT
2. Click on the Execute button (shortcut - F9)to run the query.

 How do I log the results of the SQL:
1. Use the following syntax to spool out the query results:
SELECT NAME, LOC
FROM SIEBEL.S_ORG_EXT;
OUTPUT TO C:\OUTPUT.TXT
FORMAT ASCII