RE: [sqr-users] Auto-commits

["Turner, Ivan" <Ivan.Turner@qwest.com>]

If you are on a Oracle database you can create a GLOBAL TEMPORARY TABLE.
Part of the syntax of creating this table is either ON COMMIT DELETE ROWS or
ON COMMIT PRESERVE ROWS.  This may be your best solution.

-----Original Message-----
From: Genady Sosnovsky [mailto:genadys@ontko.com]
Sent: Monday, January 06, 2003 4:53 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Auto-commits


Hi,

Binary SQR modules do not have (-XC) flag available.
Only Callable SQR ( sqr invoked via sqr API) has this option.

Here is the work around I can suggest: If you determine ( within you report
logic)
that there is a need to rollback inserted/deleted/updated data you can just
explicitly issue
ROLLBACK command or its equivalent depends on what database you use.

For Oracle:

BEGIN-PROCEDURE ora_rollback

BEGIN-SQL
  Begin
    Rollback;;
  End;;
END-SQL

END-PROCEDURE ! ora_rollback

Also, sqr will not commit data if terminated with an error.

Genady Sosnovsky
genadys@ontko.com

----- Original Message -----
From: "Poonam Auluck" <poonam.auluck@ams.com>
To: <sqr-users@sqrug.org>
Sent: Monday, January 06, 2003 2:26 PM
Subject: [sqr-users] Auto-commits


> Hi All - I was wondering if anyone came across turning the auto-commit
> functionality off in SQR.  I would like to insert some rows into a table,
> but I don't want to commit it.  I just want the data to be temporarily
> sitting in there.
>
> I thought there was a flag or maybe someplace that I can turn this off,
but
> I can't find it.  I thought the flag was -XC, which should suppress the
> database commit when the report has finished running, only when I use this
> in the command line, I get an error saying it doesn't understand it.
> Should I be typing in something else along w/ '-XC'...Do I have to put
> 'False' in there somewhere?
>
> Any help is appreciated!
> Thanks!
>
>
> _________________
> Poonam Auluck
> AMS, Inc.
> 703-227-5576
>
>
> .
>
> _______________________________________________
> 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

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