Create SEC SQLI variable that lists agents with similar names.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Here is a SQL statement that lists agents with a similar name and can be utilized by a secure SQLI variable.

SQL statement:

select oh_name from oh 
where oh_otype= ?
and oh_deleteflag = ?
and oh_client = ?
and oh_name like ?

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

How To.

Resolution

Result from the variable: