How do I pipe the output of isql to a file in Sy

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do I pipe the output of isql to a file in Sybase?

Fortunately this is one of the simple ones. For batch sessions, simply use the the -o command line switch to specify the name of the output file. For interactive sessions, the simplest method is turn on the capture functionality of your xterm window while running the query. If this isn't possible (i.e., you are not running on UNIX), then there are a couple of options:

* Use sqsh instead
* Use the tee(1) command which takes the output from a command and writes/appends it to a file, as well as displaying it on the screen. (Again, this may be UNIX-specific; Windows users should research the CYGWIN toolset for similar functionality.)

(Continued on next question...)

Other Job Interview Questions

• Fixing a Munged Log in Sybase ?
• How to emulate the Oracle decode function/crosstab in Sybase
• How do I audit the SQL sent to the server?
• How Can I Run the ASE Upgrade Manually?
• How Does Partition Assignment Relate to Transactions in Sybase?
• How do I exclude a column in Sybase ?
• Optimizing your home grown Sequential key generating process for any version of Sybase
• How can you change to get the decimal separator as comma instead of the decimal point (.)?
• How do I generate Sequential Keys w/o the Identity feature in Sybase?
• Alternative to row at a time processing in Sybase ?
• More...