Re: [sqr-users] if not exists (select * from sysobjects where name

[john.tucker@oracle.com]

I'd just like to add one thing on the command "stop" - there's an optional 
parameter that I like to use, "quiet."

"Stop quiet" kills the SQR, but just gives the "End of Run" message in the log 
file rather than an error message.  I tend to write my own error messages in 
the SQR that I'd rather see than a system error, like:

Show 'Error: Cannot continue.  Requested institution does not exist: ' 
$Institution
Stop Quiet

Either way, stop is going to get the job done for you, but adding "quiet" might 
make it look more like you want it to.

-John Tucker
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users