Errors while viewing data through Teradata Enterprise Stage
Posted: Wed Nov 16, 2005 9:03 am
Hello Forum,
I get the following Error messages while attempting to view data from client in the Teradata Enterprise stage:
My read method is user defined sql with parameter references and Connection settings is using the DB Options with $ parameter references. The parameters shown in the warnings are the ones specified in the connection settings, but in the warnings it has replaced the $ with an _.
Any suggestions?
Thanks,
Greg
I get the following Error messages while attempting to view data from client in the Teradata Enterprise stage:
However, the program runs fine and selects data from these stages with no warnings.#E TCOS 000005 09:55:01(004) <main_program> Invalid identifier: $
>##E TCOS 000048 09:55:01(005) <main_program> Parameter not resolvable:
##W TCOS 000049 09:55:01(017) <main_program> Parameter specified but not used in flow: _TDDB1
##W TCOS 000049 09:55:01(018) <main_program> Parameter specified but not used in flow: _TDPwd1
##W TCOS 000049 09:55:01(019) <main_program> Parameter specified but not used in flow: _TDUserId1
##W TCOS 000049 09:55:01(020) <main_program> Parameter specified but not used in flow: _TDPID
>##E TCOS 000020 09:55:01(023) <main_program> Parameterization Error: Parameterization failed.
My read method is user defined sql with parameter references and Connection settings is using the DB Options with $ parameter references. The parameters shown in the warnings are the ones specified in the connection settings, but in the warnings it has replaced the $ with an _.
Any suggestions?
Thanks,
Greg