While working with local we often have to use dbisqlc.exe to run queries on our Local DBF files and many times we need to export data that comes as a result of our queries.

Till yesterday I believed that there is no way to export data from dbisqlc.exe but while surfing on web yesterday I came across tip that made it possible to export data from local dbf also.

For example I want to export all the data from S_OPTY table in my local dbf. The query I would execute to get the data is.

SELECT * FROM SIEBEL.S_OPTY

To export the data to a file for the above query you have to issue the following query

SELECT * FROM SIEBEL.S_OPTY;
OUTPUT TO C:\EXPORT.TXT
FORMAT ASCII

Note: Don’t forget to put semicolon “;” after the query and before OUTPUT TO clause otherwise you will get an error.

To see number of other parameters that you can use read the following post on yet another Siebel blog called Let’s talk Siebel.

OkAvarageGoodVery GoodExcellent (2 votes, average: 4 out of 5)
Loading ... Loading ...