DBISQLC.EXE is the utility used to connect to sample/local database for DML,DDL operations. But how do we export the results of a query to a file?
By using ‘OUTPUT’ command.
SELECT * FROM SIEBEL.S_CONTACT
To export the data to a file for the above query you have to issue the following query
Note:-Don’t forget to add ‘;’ after the query and before OUTPUT TO clause otherwise you will get an error. Also make sure that a blank file exists in the path before you execute the query.