Is there any debugger option in Teradata Studio.

Database

Is there any debugger option in Teradata Studio.

Hi Everyone,

I am interested in debugging SP of my DB instance. Is there any debugger option availble in Teradata Studio 14.2.0 ?

If the debugger option is not availble TD Studio, is there any other way I can follow for tracing the procedure.

Tags (1)
4 REPLIES

Re: Is there any debugger option in Teradata Studio.

Hi Experts,

Can anyone please help me on this ?

Thanks in advance

Re: Is there any debugger option in Teradata Studio.

i do not think we have a debugger available in Studio express or in sql assistant. Usually in order to debug a large query we should be taking all the subqueries individually and start debugiing dividing the code to the finest granularity as possible.

Teradata Employee

Re: Is there any debugger option in Teradata Studio.

There is a paragraph titled "Debugging Stored Procedures" in the "SQL Stored Procedures and Embedded SQL" manual in the Teradata documentation set.

You have to think about debugging somewhat differently when the code is running in an MPP parallel system with no mechanism to write directly to the user's device. This section will give you some techniques for debugging SPs on Teradata.

Re: Is there any debugger option in Teradata Studio.

Thanks Krishaneesh !

Hi Walter, Thanks this will be usefull for my development.

Many thanks,