|
|
Thread Tools | Rate Thread | Display Modes |
#1
|
|||
|
|||
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> |
|
|