Error in calling Teradata SP using DRS stage
Posted: Sat Jul 12, 2008 1:46 am
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
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