RE: [sqr-users] sqr compile

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

If you put a STOP at the beginning of the program, the compiler will compile
the whole program, but the execution of the program won't do anything after
the STOP.  I think that's what you want to happen.  When you're ready to
execute the program, remove the STOP.

Alternately, you can make the first command an INPUT statement.  Be careful
that it doesn't read its value from your command line.  When the program
asks you for input, you can stop it yourself.

The "-RS" option on the command line will try to compile your program and
save the compiled version, but not execute it.  That's another way to
compile without executing.

As you observed, ROLLBACK doesn't reverse TRUNCATE.  It also won't reverse
file operations, like overwriting an existing file.

-----Original Message-----
From: Kaithi, Murali [mailto:Murali.Kaithi@spencergifts.com]
Sent: Thursday, September 09, 2004 6:24 AM
To: This list is for discussion about the SQR database reportinglanguage
fr omHyperion Solutions.
Subject: RE: [sqr-users] sqr compile


if I use STOP the program will not proceed further.

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 Pink, Michael
Sent: Thursday, September 09, 2004 9:10 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] sqr compile


As previously suggested code a stop before any processing occurs.

-----Original Message-----
From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org
[mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On Behalf
Of Kaithi, Murali
Sent: Thursday, September 09, 2004 9:01 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] sqr compile


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

_______________________________________________
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

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