How to run OCF / IDMSBCF in READ ONLY

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

Introduction:

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

Instructions:

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 the manual “CA IDMS SQL Reference Guide” Chapter 8 “Statements”, “SET SESSION”.

Environment

Release: IDADSO00100-18.5-ADS-for CA-IDMS
Component: