Is there any tool to debug Stored procedures in Informix? I use db Visualiser but dont see any option there. I tried SQL server studio but it doesnt show me the variable values in runtime. Any other tool or how to debug it using atleast command mode would be very helpful. Thanks.
You can use IBM Optim Data Studio (or Development Studio). It is available as a FREE download and it includes a full-featured debugger - you can step through, view/modify the value of variables, set breakpoints, step into nested procedures, etc.