Stored Procedure Session Mode Creation Details

Database
Teradata Employee

Stored Procedure Session Mode Creation Details

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.


Accepted Solutions
Junior Contributor

Re: Stored Procedure Session Mode Creation Details

Theres dbc.tvm.SPObjectCodeRows which encodes information about SPs:

 

SPObjectCodeRows/10000 MOD 10 returns 1 for Teradata mode and 2 for ANSI mode sessions in 15.10 (but this might change in different releases, double check)

1 ACCEPTED SOLUTION
2 REPLIES
Junior Contributor

Re: Stored Procedure Session Mode Creation Details

Theres dbc.tvm.SPObjectCodeRows which encodes information about SPs:

 

SPObjectCodeRows/10000 MOD 10 returns 1 for Teradata mode and 2 for ANSI mode sessions in 15.10 (but this might change in different releases, double check)

Highlighted
Teradata Employee

Re: Stored Procedure Session Mode Creation Details

Hi dnoeth,

 

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.