Error in calling Teradata SP using DRS stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rakesh.nc
Participant
Posts: 39
Joined: Wed Aug 01, 2007 5:10 am
Location: Chennai

Error in calling Teradata SP using DRS stage

Post by rakesh.nc »

Hi all,

Requirement is to call a Teradata stored procedure, to do so, we are using DRS stage.
Dataset will the Input for this job.

In DRS stage, under the user-define page we are using the below syntax to call the teradata SP.

CALL
databasename.sp_name (
: parameter1,
: parameter2,
: parameter3
);

When we run the job, we are receiving the following warnings and errors,

Warning: Dynamic_RDBMS_493: SQLSetConnectAttr (SQL_ATTR_TXN_ISOLATION) failed.
Warning: Dynamic_RDBMS_493: [DataDirect][ODBC Teradata Client Driver] optional feature not implemented.
Info: APT_CombinedOperatorController,0: Operator terminated abnormally: received signal SIGSEGV
regards,
Rakesh
Post Reply