All Forums Database
Vinodraj 12 posts Joined 01/13
18 Jul 2014
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.

-

Vinod

Tags:
Vinodraj 12 posts Joined 01/13
21 Jul 2014

Hi Experts,
 
Can anyone please help me on this ?
 
Thanks in advance

-
Vinod

krishaneesh 140 posts Joined 04/13
21 Jul 2014

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.

ToddAWalter 316 posts Joined 10/11
21 Jul 2014

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.

Vinodraj 12 posts Joined 01/13
21 Jul 2014

Thanks Krishaneesh !
 
Hi Walter, Thanks this will be usefull for my development.
 
Many thanks,
 
 
 

-
Vinod

You must sign in to leave a comment.