|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| isql input file with multiple sql statements | Cailet | Shell Programming and Scripting | 0 | 02-16-2009 06:08 PM |
| AIX to access MSSQL server | hellboy01 | AIX | 0 | 12-17-2008 11:09 AM |
| Unload utility with loop method | cedrichiu | Shell Programming and Scripting | 1 | 07-02-2007 09:55 AM |
| Is there any way to unload *.so by force? | princelinux | Linux | 0 | 04-10-2006 12:18 PM |
| connect to mssql | ahmedwaseem2000 | Shell Programming and Scripting | 3 | 10-18-2005 10:56 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
07-20-2009
|
||||
|
||||
|
linux ISQL and MSSQL unload results to file
Hello,
I am using suse 10.1 and isql from unixodbc to connect to a MS SQL server. I got everything to work fine. What do I need to unload the results from the sql to a file? I attempted to put unload to in my sql statement but got a error. I don't see in the isql help where it has a option to unload to files, I read about a -o option but the isql I am using doesn't have that option. Guess I either need to know how to unload the results using MS SQL's or how to do it from ISQL. I set the delimiter to pipe and attempted to redirect the output but got all of the isql login stuff. Thanks. ---------- Post updated at 11:17 AM ---------- Previous update was at 11:01 AM ---------- I figured it out, I just needed to add on the -b optoin, and the redirecting of the output now just includes the results. Thanks. |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
