In preview for a Select in a SEC_SQLI Variable using bind parameter the first row of the result is taken as the column header

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

When you click preview in the SEC_SQLI with the variableas bind parameter, the first row of the result is taken as the column header:

<Please see attached file for image>

If you use a fixed value (literal) instead, it works as expected:

<Please see attached file for image>

 

Environment

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Cause

Cause type:
Defect
Root Cause: N/A

Resolution

This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Version(s):
Automation.Engine 10.0.6 - already released
Automation.Engine 11.1.2 - already released
Automation.Engine 11.2.0 - already released

Additional Information

Workaround :
N/A