Archives of the TeradataForum

Message Posted: Mon, 28 Mar 2016 @ 19:44:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Forum,

We have two Teradata servers (Dev and prod) of exact same version (version - 15.00.03.03 , Release - 15.00.03.04). I am trying to compile a store procedure on production server which was recently upgraded and it is failing with the below error.

Missing/Invalid SQL statement'E(9267):A nondeterministic SQL expression passed as an argument to an SQL UDF cannot correspond to a parameter that appears more than once in the return statement.

However the same procedure runs perfectly on the development server.

I had posted a question on the above error I got few days back and the response I received was to use CHAR_LENGTH instead of LENGTH. However now after the upgrade I am expecting the procedure to compile without any issues on the prod server.

Could this be due to the default database (SYSLIB/TD_SYSFNLIB) that is used to pull the functions different in prod and dev server?

Could someone please clarify? Appreciate the response.

Thanks

Roopalini

	<Prev	Next>		<<First	<Prev	Next>	Last>>