Problem Note 5894: "ERROR: Informix EXECUTE Error: Already in transaction" is issued in
SAS 8.2
The following error message is issued using SAS/ACCESS Interface to
INFORMIX with SAS 8.2. The same code worked correctly with SAS 8.1.
ERROR: Informix EXECUTE Error: Already in transaction
This is a SAS 8.2 bug. We should not be issuing any "COMMIT WORK" or
"BEGIN WORK" statements while processing explicit passthrough SQL.
To circumvent this problem, add -nosyntaxcheck to the SAS command line.
Of course, keep in mind that this would alter the behavior of jobs with
other sorts of SAS failures, which might be undesirable.
Alternatively, you can use PROC SQL NOERRORSTOP; this may circumvent the
problem, but would require changing the SAS code.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#005894
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Informix | Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| IRIX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| ABI+ for Intel Architecture | 8.2 TS2M0 | 8.2 TS2M0 |
| Linux | 8.2 TS2M0 | 8.2 TS2M0 |
| HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| Tru64 UNIX | 8.2 TS2M0 | 8.2 TS2M0 |
| AIX | 8.2 TS2M0 | 8.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Informix
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2002-04-29 13:15:10 |
| Date Created: | 2001-09-19 11:40:27 |
