search cancel

Appplications Manager support for Tereadata database

book

Article ID: 88452

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Appplications Manager support for Tereadata database

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Symptoms

After configuring a DB login to communicate with the Tereadata DB jobs fail. 

The login object in the output file will show the type as other.

 


 

Cause

 

SQL script was being run against the Tereadata DB.

 

 


 

 

Resolution

Tereadata has its own interactive language, and will not work with SQL scripts. Converting the SQL script to BTEQ to resolve the issue.