Highlighted
Absent Member.
Absent Member.
437 views

[archive] How does MSSQL Transaction work with ACUSQL?

[Migrated content. Thread originally posted on 28 October 2010]

I have the code like



           EXEC SQL
             BEGIN TRANSACTION T1
           END-EXEC.
           EXEC SQL
             DELETE FROM csifsa23
             WHERE wpw_password = '5682'
           END-EXEC.
           EXEC SQL
             COMMIT TRANSACTION TI
           END-EXEC.



But when I run it, I got the error like



[ATTACH]459[/ATTACH]


I see simlilar question in forum:
http://www.acucorp.com/support/supported/customer_forum/showthread.php?t=1618&highlight=sql
0 Likes
2 Replies
Highlighted
Absent Member.
Absent Member.

RE: [archive] How does MSSQL Transaction work with ACUSQL?

It appears that your begin specifies T1 (tee one) whereas the commit specifies TI (tee eye)
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] How does MSSQL Transaction work with ACUSQL?

It appears that your begin specifies T1 (tee one) whereas the commit specifies TI (tee eye)


Sorry, that's a typo. It should both be "T1"(tee one).


I am testing with acuSQL8.1.1 on MSSQL Transaction and I write the following codes:

EXEC SQL
BEGIN TRANSACTION T1
END-EXEC.
EXEC SQL
DELETE FROM csifsa23
WHERE wpw_password = '5682'
END-EXEC.
EXEC SQL
COMMIT TRANSACTION T1
END-EXEC.
I got error message as:

"Cannot issue SAVE TRANSACTION when there is no active transaction."

I tested the following codes in MSSQL Server:
BEGIN TRANSACTION T1
DELETE FROM csifsa23
WHERE wpw_password = '5682'
COMMIT TRANSACTION T1
It works.

In AcuSQL User's Guide Version 6.1, it provide
ASQL_TRANSACTION_METHOD configuration variable.But in
AcuSQL User's Guide Version 8.1.1 , it does NOT provide
this cinfigruation variable.

However,I tried to use configuration variable ASQL_TRANSACTION_METHOD in acuSQL8.1.1 in the "cblconfi" file as:
"ASQL_TRANSACTION_METHOD EXPLICIT"
It still gave me same error.

I could not see any sample programs provided with acuSQL 8.1.1 on MSSQL Transaction.

My question is
1.Could you explain how acuSQL works with MSSQL Transaction, does the example I provided have any problem?

2.Does acuSQL8.1.1 still support ASQL_TRANSACTION_METHOD configuration variabl?If so, how is it used? Could you provide an sample program?
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.