0

I have a stored procedure in Sybase that uses reorg rebuild statement in a loop for all the tables in my database. What I want to do is to suppress the reorg rebuild sysmessages for tables that succedeed the procedure and only to print the tables that were locked etc...thus the problematic ones....The thing is that I did not succeed to find out anything to use in manual or in any workshops...dow you have any idea?

Thanks in advance !!!!!

sgian76
  • 89
  • 1
  • 7

1 Answers1

0

If you are running the SQL with isql at a command prompt, you can always capture the output in a text file and filter it out with other tools.

Create a script to run the SQL in isql and then use a script that calls a text processing tool (awk,sed,...) to only find the lines of interest.

Here is an example from a windows batch file with a regex that removes lines that start with a space (i.e. Rows Effected messages)

isql -SDBDEV1 -DMyDbName -U%DBLOG% -P%DBPWD% -iLoadBatchStats.sql -o%TEMP%\LoadBatchStats.log
type %TEMP%\LoadBatchStats.log | gawk "/^[ ]/{print $0}" >>%TEMP%\LoadBatchSummary.log
Rawheiser
  • 1,200
  • 8
  • 17