Variables not populated after SELECT SQL statement execution

Products

• OPS/MVS Event Management & Automation

Issue/Introduction

When reading a table in a security rule with a SQL statement like below:

address sql                                               
"SELECT CURRENT_STATE from STCTBL WHERE NAME='STCA'"
say 'SQLCODE 'sqlcode                                     
say 'Current State of 'resource 'is 'CURRENT_STATE.1  

Even if the resource if found in the table the variable CURRENT_STATE.1 contains the variable name instead of the correct current state of the resource. 

 

Environment

OPS/MVS

Resolution

One possible cause is a low value of the parameter STACKMAIN.

Increasing the value of this parameter and recycling OPSMAIN may solve this problem.

 

Additional Information

Memory/Storage Parameters - STACKMAIN