when I right click the Join and click on Properties, I check the option "Use the Optimized pass-through facility for SQL statements"; when I run with this, the column using the function errors with: ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, , =, , =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. 2994 SYSLIB.ERAC_LCL_TO_GMT(RNT_AGRS.due_ci_tmsp , OPTMZ_GRP_BR_CURR_AIRPT.grp_br_tmz_c de ) as EVNT_GMT_TSP length = 8 _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <> , =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~ =. ERROR 76-322: Syntax error, statement will be ignored. 2995 format = Datetime. 2996 informat = Datetime. 2997 label = 'gmt timestamp when rental was due to be returned', this SQL statement is successfully tested in Teradata directly, but will not run for DIS?
... View more