DBISQLC.EXE - Gateway to Siebel Local Database

What is DBISQLC.EXE?
DBISQLC.EXE is an Interactive SQL Anywhere program, located in the Siebel Tools or Siebel Web Client folder, and is used to connect to sample/local database for DML, DDL operations.

Where can I find DBISQLC.EXE?
It can be found in BIN folder of Siebel Tools or Siebel Web Client. For ex, D:\Siebel\8.2.2.0.0\Client_1\BIN\dbisqlc.exe

How Do I run a query?
1. In the Command sub-window, type the query you want to perform. Make sure that you put the table owner name in front of the Siebel table names (i.e. SIEBEL.S_CONTACT instead of just S_CONTACT).
SELECT FST_NAME, LAST_NAME FROM SIEBEL.S_CONTACT;

2. Click on the Execute button (F9) to run the query.

How do I export the results of the SQL:
We can do this by using OUTPUT TO command.
You can export the results to a TXT file. Below is an example,
SELECT FST_NAME, LAST_NAME FROM SIEBEL.S_CONTACT;
OUTPUT TO C:\OUTPUT.TXT
FORMAT ASCII

You can export the results to a CSV file. Below is an example,
SELECT FST_NAME, LAST_NAME FROM SIEBEL.S_CONTACT;
OUTPUT TO C:\OUTPUT.CSV
FORMAT ASCII