RE: [sqr-users] sqr compile

[Dattatraya Shetty <datta_shetty@yahoo.com>]

Murali,
   One other way I can think of is use #debug Statements around all
truncates and don't let the truncate procced.

Then incase you have inserts on the table and the this results in
duplicates you can trap the SQL Error and choose to ignore that row
being inserted. 

Else 

   For time being change all the truncates to deletes and then Issue a
Rollback in the end. 

Best is to always have a Test Environment. :) But I do understand some
times things need to be fixed in production directly. 

HTH 
Datta. 
--- "Kaithi, Murali" <Murali.Kaithi@spencergifts.com> wrote:

> 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-----
> From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org
> [mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org]On
> Behalf Of Dattatraya Shetty
> Sent: Thursday, September 09, 2004 8:51 AM
> To: This list is for discussion about the SQR database reporting
> languagefrom Hyperion Solutions.
> Subject: RE: [sqr-users] sqr compile
> 
> 
> 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-----
> > From: Kaithi, Murali [mailto:Murali.Kaithi@spencergifts.com] 
> > Sent: Wednesday, September 08, 2004 11:49 PM
> > To: This list is for discussion about the SQR database
> > reportinglanguage from Hyperion Solutions.
> > Subject: [sqr-users] sqr compile
> > 
> > 
> > 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
> > 
> >
>
______________________________________________________________________
> > This email has been scanned by the MessageLabs Email Security
> System.
> > For more information please visit http://www.messagelabs.com/email 
> >
>
______________________________________________________________________
> > 
> > 
> > 
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> > 
> 
> 
> 
>               
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - 50x more storage than other providers!
> http://promotions.yahoo.com/new_mail
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
>
______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
>
______________________________________________________________________
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 



                
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

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