How to run OCF / IDMSBCF in READ ONLY mode

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

Is it possible to run an OCF session (or IDMSBCF batch job) such that it will access the database in READ ONLY mode?

Environment

IDMS - all supported releases

Resolution

Yes.

Place the syntax SET SESSION READ ONLY; after the CONNECT and before the rest of the input.

For example:

CONNECT TO APPLDICT;
SET SESSION READ ONLY;
SELECT * FROM DEMOPROJ.EMPLOYEE;

Additional Information

For more information, see IDMS SQL Reference section “Statements”, “SET SESSION”.