ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Create SEC SQLI variable that lists agents with similar names.

book

Article ID: 212593

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine 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 ?

Cause

How To.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Result from the variable:

Attachments