Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Understanding what /w500, /n, /e, /d, and -s mean

Author  Topic 

cirugio
Yak Posting Veteran

90 Posts

Posted - 2010-05-20 : 11:03:01
I just inherited some Transact code which appears to be executed through osql. I am trying to figure out what it all means. Below is a small portion of it, would someone be able to help me determine what the /w500, /n, /e, /d, and -s mean in the logic below?

Also, it appears the output is stored into the \SourceData\ExceptionsReports\ folder on some drive. How do I determine what drive its under?

if Right(@RptName, 3) = 'CSV'
Select @Cmd = **'osql /w500 /n /E /dQRM_TDM_DATA' +
' /qdbo.[' + @RPTName + '] >\\' + @@SERVERNAME +
'\SourceData\ExceptionReports\' + @FileName + ' -s ",""'
else**

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-05-20 : 11:51:27
Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=144906
Go to Top of Page
   

- Advertisement -