Issue wit data extraction

[sagar deshmukh]

I Have query defined in Teradata enterprise stage as below:

select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr
where cldr_dt = '#Current_Date#'


'#Current_Date#' is a parameter which I am passing through sequencer.

But the job aborts with below error :

Teradata_Enterprise_24,0: APT_TeraReadOperator:DB Call Failure(success check) Info = 0, Code = 3695, Message = A Single AMP Select statement has been issued in FastExport. 3,695
APT_TeraReadOperator:ExecuteImmediate failed for 'select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr where cldr_dt = '2011-04-27' '. Error Code = 3695 3,695

If just run this query in SQL assistant it works fine:

select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr where cldr_dt = '2011-04-27'

Please help me out with this.


Thanks
Sagar

[chulett]

"DB Call Failure(success check) Info = 0, Code = 3695, Message = A Single AMP Select statement has been issued in FastExport"

Why not address the error the job reported?

[throbinson]

I believe this is a limitation of Teradata's FastExport. From the DS documentation on the teraread Operator.

v Single-AMP requests are not allowed. These are SELECTs satisfied by an equality term on the primary index or on a unique secondary index.

Meaning use the Teradata API instead. Disclaimer: This makes sense in pre 8 DataStage.