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.
VARA.SQL and VARA.SQLI delivers no result on on system, and a result on another
Article ID: 87881
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
If the same VARA.SQL or VARA.SQLI gives results in one system and no results in another, please check in Microsoft ODBC Administrator if if both options are checked like in the screenshot below:
<Please see attached file for image>
Cause
Cause type:
Configuration
Root Cause: Both options must be checked.
Configuration
Root Cause: Both options must be checked.
Environment
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:
Component:
Resolution
Make sure both "Use ANSI quoted identifiers" and "Use ANSI nulls, paddings, and warnings" options are checked in Microsoft ODBC Administrator.
Fix Status: No Fix
Fix Version(s):
N/A
Fix Status: No Fix
Fix Version(s):
N/A
Additional Information
Workaround :
N/A
N/A
Attachments
Feedback
Yes
No
Powered by
