[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] SQR run in DB2 with commits in the code

Hi,
This is what i found.....Can you giver the details what is the
requiremnt.Hope this is helpful.

COMMIT is useful when you are doing many inserts, updates, or deletes in an
SQL
paragraph. A database commit releases the locks on the records which have
been
inserted, updated, or deleted. Used with some databases, it also has other
affects. For
example, used with ORACLE, it closes SELECT cursors. For this reason, it
should not
be used within the scope of an active SELECT paragraph or unpredictable
results may
occur.
When the application completes, a commit is performed automatically unless a
ROLLBACK was done or, for callable SQR, the -XC flag was set.
Other commands or options, such as the CONNECT command and the use of DDL
statements for some databases with a BEGIN-SQL paragraph, can also cause the
database to do a commit.
COMMIT is an SQR command and should not be used within an SQL paragraph. If
used in an SQL paragraph, unpredictable errors may occur.

Note: The COMMIT command can be used with DB2, Informix, Ingres, ODBC,
ORACLE,
and SQLBase. (Microsoft SQL Server is accessible with SQR Server for ODBC.)
For SYBASE and Microsoft SQL Server, use BEGIN TRANSACTION and
COMMIT TRANSACTION within SQL paragraphs as in the code segment shown
below.

Regards,
Vijay.

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Ashish Bhatt
Sent: Thursday, February 26, 2004 7:54 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR run in DB2 with commits in the code


Hi SQR Gurus,

I hope you are doing fine today.

Has anyone of you have run SQR on DB2 database with the commit at regular
interval in the SELECT in the SQR code?

We are facing serious infinite looping issue.

Please reply.

Have a nice day and great week.

Regards.

Ashish Bhatt.
716 841 4349 (Work)

_________________________________________________________________
Take a break! Find destinations on MSN Travel. http://www.msn.com.sg/travel/

_______________________________________________
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