CA Easytrieve plus with iIDMS SQL getting a security error

Document ID : KB000101581
Last Modified Date : 14/06/2018
Show Technical Document Details
Introduction:
IDMS retrieval for an SQL CA Easytrieve job.
Question:
Can you specify retrieval only for an SQL easytrieve job? If so, how do you do it? We are getting an update security issue when only doing retrieval.  
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 
Answer:
CA Easytrieve is working as designed at this time. It appears that IDMS readies everything in update mode from SQL. If you are 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. I am not sure if building a read only DMCL would allow them to do what they are asking. If this is something that the customer feels is needed they can bring it up with the CA IDMS folks or they could open an enhancement request to CA Easytrieve. In either case it is not a simple change and I think both CA IDMS and CA Easytrieve teams need to be involved in resolving this issue.
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.