CA Easytrieve with IDMS SQL getting a security error
Article ID: 101581
Updated On:
Products
PanAudit Plus
Easytrieve Report Generator
PAN/SQL
Issue/Introduction
IDMS retrieval for an SQL CA Easytrieve job.
Does CA Easytrieve have the functionality included to only retrieve and not update IDMS SQL?
Why is CA Easytrieve opening up the IDMS file in UPDATE mode for a SELECT?
Does CA Easytrieve have the functionality included to only retrieve and not update IDMS SQL?
Why is CA Easytrieve opening up the IDMS file in UPDATE mode for a SELECT?
Environment
CA Easytrieve for IDMS running in 11.6-c compatibility mode
Have an Easytrieve program with a SELECT * FROM SQLCHEMA,
with only Retrieval access to the SQLCHEMA
Have an Easytrieve program with a SELECT * FROM SQLCHEMA,
with only Retrieval access to the SQLCHEMA
Resolution
CA Easytrieve is working as designed at this time. It appears that IDMS readies everything in update mode from SQL. If running a product like Culprit it, checks for select statements and sets the transaction as read only. Easytrieve is not using transactions like Culprit and it is designed to allow full update of the database.
Additional Information
Client's job worked because they have update authority, an associate's job failed who doesn't have update authority..
Access is defined in the DMCL for IDMS
The open is dependent on settings in the DMCL.
DMCL is the IDMS definition of a database and it includes default access settings.
Access is defined in the DMCL for IDMS
The open is dependent on settings in the DMCL.
DMCL is the IDMS definition of a database and it includes default access settings.
Feedback
Yes
No
Powered by
