Hi Everybody,
Is there a way for calling a function with more than 1 return value?
What are the debugging tools used in Datastage apart from Debugger in Datastage Designer?
Thanks
Few Questions
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A function (by which I assume you mean a Routine whose type is Transform Function) in DataStage can have only one return argument.
However, this can be any data type, including a dynamic array. If you use a dynamic array you can return as many actual values as you like.
As well as the interactive Debugger you can trace the rows passing through any active stage (stage tracing), you can include statements in routines - particularly before/after routings - that log events into the job log, you can employ server side tracing to determine what is happening between clients and server, and you can use the data browser (particularly its selective display and Find capabilities) as a debugging tool.
(There's also peer review, if there's more than one of you working on the project, and (naturally) this forum!)
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
However, this can be any data type, including a dynamic array. If you use a dynamic array you can return as many actual values as you like.
As well as the interactive Debugger you can trace the rows passing through any active stage (stage tracing), you can include statements in routines - particularly before/after routings - that log events into the job log, you can employ server side tracing to determine what is happening between clients and server, and you can use the data browser (particularly its selective display and Find capabilities) as a debugging tool.
(There's also peer review, if there's more than one of you working on the project, and (naturally) this forum!)
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518