Page 1 of 1
Can we see a Job's Code
Posted: Thu Jan 27, 2005 2:21 pm
by anandkumarm
Hi,
Can we see a DataStage Job's Basic code?. I understand that we can see a Job sequence's code in the Job control, but is there any way in which we can see Basic code for a Job.
Thanks,
Anand.
Re: Can we see a Job's Code
Posted: Thu Jan 27, 2005 3:04 pm
by ogmios
The easiest way for you probably is to export the executable code of a job via DataStage manager and then open that file in Notepad: you will see big piece of the generate code.
Not that it matters since you can't change the code generated from a GUI job.
Ogmios.
Posted: Thu Jan 27, 2005 3:18 pm
by kduke
In earlier versions of DataStage this was an easy way to see how a job works. This is not as simple any more. There is a RT_BPnnn file where nnn is the job number. This does get compiled. I doubt if you could still look at the generated code. Hack it and see. I am sure ASCL will be thrilled to see we are looking under the covers.
Some of the hacking is beneficial. I did look at the code generated in a sequence to see why the exception handler did not trap jobs without warning links. I do not like the way they implemented that. I think some of the SQL against DS_JOBOBJECTS is useful. Let us know what you figure out.
Posted: Thu Jan 27, 2005 3:28 pm
by ray.wurlod
A job is executed by a BASIC routine called DSD.RUN. Source code for this is not available.
A Transformer stage is executed by a BASIC routine called DSD.StageRun. Source code for this is not available.
The code generated for a Transfomer stage by compiling a job can still be viewed in RT_BPnnn, where nnn is the job number from DS_JOBS. This, and job control code, is the only part of the code that you can see.
Note that this is for server jobs only.
Posted: Fri Jan 28, 2005 8:38 am
by anandkumarm
ray.wurlod wrote:A job is executed by a BASIC routine called DSD.RUN. Source code for this is not available.
A Transformer stage is executed by a BASIC routine called DSD.StageRun. Source code for this is not available.
The code generated for a Transfomer stage by compiling a job can still be viewed in RT_BPnnn, where nnn is the job number from DS_JOBS. This, and job control code, is the only part of the code that you can see.
Note that this is for server jobs only.
Thank you very much for all you guys for explaining.
Anand.