Wednesday, September 30, 2009

Export Data using dbisql.exe

Recently I found that there is one more way apart from using #getuid.out
which I post in my previous blog 'Query Result to file using dbisqlc'

select name from SYSUSERAUTH
where name not in ('SYS','DBA','PUBLIC','SIEBEL','DBO','dbo','SSE_ROLE') >#getuid.out

The other way to export the date into other file format is using output command.

After you execute your query.
You need to execute command having syntax

output to filename

output format can be in excel.

Sharing is the power

No comments:

Post a Comment