Archives of the TeradataForum
Message Posted: Mon, 28 Mar 2016 @ 19:44:33 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|