SQL job truncates result.

book

Article ID: 207468

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

A SQL job truncates the result of a select statement.

Report:

Running the same select statement through i.e. Management Studio returns the following output:

Cause

Configuration.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Change the value for 'Maximum characters in column' inside the SQL job --> Tab SQL --> Result Table Settings to a higher value:

Now the SQL job returns the same result as the Management Studio.

Attachments