1.what function I need to use for looking on a string/variable for a given input.
for eg.,
I want to check whether the string '0123' is present inside a variable which has a value 0123456? which function shuld I use?
2.which function shuld I use for replacing the character by another?
for eg., in the value '123,456' I want to replace the comma by null.
pls explain.
3.I am creating parallel jobs.I heard that debugging cant be done as there is no debugger available in DataStage, is this true?
pls explain me how to use it, if it is available...
Thanks a ton!
lookup on a string or variable & Debugger
Moderators: chulett, rschirm, roy
Hi,
Debugging can be done via peek stage, throwing some sample data to log or simply by dumping records to sequentiql or dataset files.
IHTH,
Debugging can be done via peek stage, throwing some sample data to log or simply by dumping records to sequentiql or dataset files.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)