Kinook Software Forums

Go Back   Kinook Software Forums > Visual Build Professional > [VBP] Third Party Tools

 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-23-2007, 10:12 AM
BrandonG BrandonG is online now
Registered User
 
Join Date: 11-13-2006
Posts: 12
How to supress output into the log window using Run SQL (ISQLW)

I have a problem with trying to get the SQL output to supress. I am using the standard Run SQL with the exception that I changed the EXE to isqlw due to the way that OSQL was processing some special characters in my scripts. Below are the 3 ways that I have tried configuring the step(s) (there are 20 or so) to supress output with no luck.

Can anyone offer any assistance

First:
<step action='Run SQL'>
<Abort type='11'>0</Abort>
<Database>C1DAT</Database>
<InputFile>%Script_Get_Location%\Installation\Veri fy Script\Val_DB.sql</InputFile>
<Location>isqlw</Location>
<Output type='3'>1</Output>
<OutputFile>%Script_Get_Location%\%SS_VERSION%Vali date_Central_Db.sql</OutputFile>
<Password>%validate_SA_Pass%</Password>
<SecType type='3'>1</SecType>
<Server>%COMPUTERNAME%</Server>
<UserName>sa</UserName>
<Width>10000</Width>
<indent type='3'>2</indent>
<name>Val_DB.sql</name>
<nologging type='11'>-1</nologging>
</step>

Second:
<step action='Run SQL'>
<Abort type='11'>0</Abort>
<Database>C1DAT</Database>
<InputFile>%Script_Get_Location%\Installation\Veri fy Script\Val_DB.sql</InputFile>
<Location>isqlw</Location>
<Output type='3'>1</Output>
<OutputFile>%Script_Get_Location%\%SS_VERSION%Vali date_Central_Db.sql</OutputFile>
<Password>%validate_SA_Pass%</Password>
<SecType type='3'>1</SecType>
<Server>%COMPUTERNAME%</Server>
<UserName>sa</UserName>
<Width>10000</Width>
<indent type='3'>2</indent>
<name>Val_DB.sql</name>
<nologging type='11'>0</nologging>
</step>

Third:
<step action='Run SQL'>
<Abort type='11'>0</Abort>
<Database>C1DAT</Database>
<InputFile>%Script_Get_Location%\Installation\Veri fy Script\Val_DB.sql</InputFile>
<Location>isqlw</Location>
<Output type='3'>1</Output>
<OutputFile>%Script_Get_Location%\%SS_VERSION%Vali date_Central_Db.sql</OutputFile>
<Password>%validate_SA_Pass%</Password>
<SecType type='3'>1</SecType>
<Server>%COMPUTERNAME%</Server>
<UserName>sa</UserName>
<Width>10000</Width>
<indent type='3'>2</indent>
<name>Val_DB.sql</name>
</step>
Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 08:51 AM.


Copyright 1999-2019 Kinook Software, Inc.