DSXchange

Hi, I am new to DS. Now clo9cking 8 hours. My CV has been updated.
ANyway, I am writing a function and need to debug it. How can I do this? Is there a tool or utility I can put it in and check it. I am not that good with basic code and using a debugger is the best way, I feel, to learn.

Thanks
Regards
Ian

There is no debugger, you to do it the traditional way and use inline command. The Print does a bit of help

The tool with which you write a routine in DataStage not only allows you to write and compile it, but it also has a "test" button which lets you call it independantly from a DataStage job. and to pass parameters to it. This is what is used to debug most routines. The DataStage engine has a source-level debugger for code, but this is not available in the graphical front-end and I've found the "test" facility along with judicious use of a PRINT statements for debugging purposes is more than enough.

You may need to double-click the results section in the test grid to see the output of the print statements though.

I prefer to use DSTransformError() or DSLogInfo() to PRINT. You can also use compiler directives $DEFINE, $IFDEF, $IFNDEF, $ELSE and $ENDIF to "conditionally compile" your debugging statements. When debugging is done, simply change $DEFINE to $UNDEFINE and recompile, and your debugging statements - though remaining present in the source code - are no longer compiled in the working routine.

Consider building the "Ans" result as a text string during development. When you run the test button, you'll be able to double-click on the results and see a verbase description of results. When finished, change the derivation for "Ans" to just return the appropriate result.