I want to get session mode(ANSI/Teradata) details for the creator of stored procedures. I know there is sql statement "HELP PROCEDURE procedure_name ATTRIBUTES;" that gives me those details but
I am writing a query that should give me all stored procedures and their respective creation session modes(ANSI/Teradata).
To whom, i should join dbc.tables to get this session mode detail.
Solved! Go to Solution.
Thanks, it worked, just the thing i was looking for. I have just tried it out on my Teradata version and it has shown me result as i was expecting them to be. I will also try to run it on some of other versions for further confirmation. Thanks, man.