Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL error-handling

Status
Not open for further replies.

parisi

Computer
Apr 22, 2005
1
Hi,

I am working with Sybase Database and want to copy a table from a runing database in a file. I do it as follows:

dbisqlc -q -c "uid=dba;pwd=sql; dsn=DSN_ODBC_NAME"; select * from TABLE_1; output to c:\table_1.txt

It works properly. In case of a error(such as write protected drive) shows Interactive SQL a message. Because I use this command in another application(WINCC with C script) I would like to catch this error and produce a new user friendly message instead of original message.
How can I do it.

Thanks in advance,

parisi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor