Re: [Emerald] SQL Script

Dale E. Reed Jr. ( (no email) )
Wed, 20 Sep 2000 11:45:49 -0700

Dan Wood wrote:
>
> Can anybody help me with a SQL script that will send the results
> of a Select statement to a text file.

C:\>isql /?
isql: unknown option ?
usage: isql [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input] [-x max text size]
[-L list servers] [-c cmdend]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-O use Old ISQL behavior disables the following]
<EOF> batch processing
Auto console width scaling
Wide messages
default errorlevel is -1 vs 1
[-? show syntax summary (this screen)]

So something like:

isqlw -S server -U sa -P password -Q "Emerald..ProcName" > file

Will send the results to a file. Then just create ProcName with the
query that you want to run, or put something like
"Select * From Emerald..RadLogs" for the query.

-- 

Dale E. Reed Jr. Emerald and RadiusNT/X__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart