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.
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.
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.