RE: [sqr-users] sqr compile

["the dragon" <ceprn@hotmail.com>]

if you just want to compile it, execute with the -RS switch.

peace,
clarrk 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

I concur.  code a stop first, the code will go through the compile stage,
get to the execution stage and stop itself before any processing starts.  Or
do a goto at the beginning that goes to the end.  just skip all execution



-----Original Message-----

As previously suggested code a stop before any processing occurs.

-----Original Message-----


That's what my problem is. Rollback will be of no use for me as I have
truncates in my program.
I am still waiting on for proper solutions from you guys to compile the
program without actually executing it.

Thanks,
Murali


-----Original Message-----

I think only problem with Rollback is that if the tables have been
truncated and not deleted then it is of no use.

--- "Sapitan, Mary Ann (MG)" <MSapitan@dow.com> wrote:

 > I think you could try putting a rollback command at the end of the
 > sqr and still run it so as not to have the changes be committed to
 > the database.
 > Anyway, if your sqr would have syntax errors, it wouldn't reach the
 > end of the program and roll back anyway. :)
 >
 >
 >
 > Thanks,
 > Ma-an Sapitan
 > * (632) 841-0111 loc. 4549
 >
 >
 > -----Original Message-----
  >
 >
 > I want to compile a sqr for any syntax errors etc without actually
 > executing the program. I dont want the program to execute as it has
 > lot of database truncates and updates. I just need a way to compile
 > the sqr. Any ideas?
 >
 >
 > Thanks,
 > Murali



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