Hi - I have Created it using SQL Assistant but getting error that ..'the proc. is in Teradta Mode' for some other user who was trying to execute it.
I Changed my ODBC Connection to use 'ANSI' instead of 'System Default' and it worked fine, Thanks for all Help.
when i try to run the procedure in sql assistant or even BTEQ, in what ever mode i.e ANSI, DEFAULT etc, can we check for any dbc table about that procidure , it ran in what mode?
If you're on TD15 (possibly 14) then use column TxnMode in table DBC.DBQLogtbl.