Skip to Content
0
Jun 12, 2014 at 09:14 PM

DS 4.2 lookup_ext custom SQL with constant value in where clause

555 Views

I have the following custom SQL in a DS 4.2 lookup_ext (going against a Teradata database table):

locking row for access

select zdomain

,zaccount

,standard_format

,zparameter

,process_type

,pattern

,active

from [$$TeradataGDQDataAlias].ds_dictionary_firm_pattern

where active = 'Y'

The job runs fine without the "where active = 'Y'" but when I add this where clause I get the following validation error:

[Function Call:lookup_ext]

NRDM Function <Syntax error at line <10>: <where active = 'Y'']) SET

("run_as_separate_process"='no', "output_cols_info"='<?xml

version="1.0" encoding="UTF-8"?><output_cols_info><col index="1"

expression="no"/>>: near <Y> found <identifier> expecting <',', ']'>.

1 error(s), 0 warning(s).

Check and fix the syntax and retry the operation. (BODI-1112394)> (BODI-1111191)

Can a constant value be referenced in a where clause within a lookup_ext custom SQL?

Thanks,

Brad