Functions to get total number of records
Moderators: chulett, rschirm, roy
Functions to get total number of records
Hi Gurus ,
I have a situation like want to get how much records inserted in the target, and also status of the job in a table during runtime, is there any functions or logic in dastage parallel, please help in this regard thanks in advance.
[* Note - Title changed to be relevant to topic - Andy *]
I have a situation like want to get how much records inserted in the target, and also status of the job in a table during runtime, is there any functions or logic in dastage parallel, please help in this regard thanks in advance.
[* Note - Title changed to be relevant to topic - Andy *]
Ramesh Kumar.M
Please use meaningful subject lines, it helps searchers of the site. Your Subject and Additional Info should have been swapped, that or just skipped the whole "Hi" part as we're quite the friendly bunch and are all about the solutions.
All that can be done "after job" from either your O/S or by another job, simplest would be from a Server job because of the BASIC functions that do this. Check your online help for all of the DSGet* functions or the equivalents using dsjob from a command line script. Read about that in the Command Line Interface chapter of either Developer's Guide pdf.
All that can be done "after job" from either your O/S or by another job, simplest would be from a Server job because of the BASIC functions that do this. Check your online help for all of the DSGet* functions or the equivalents using dsjob from a command line script. Read about that in the Command Line Interface chapter of either Developer's Guide pdf.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I need in Parallel only
Thanks for your Immediate reply, but it very thank full if u give solution in Parallel.chulett wrote:Please use meaningful subject lines, it helps searchers of the site. Your Subject and Additional Info should have been swapped, that or just skipped the whole "Hi" part as we're quite the friendly bunch and are all about the solutions.
All that can be done "after job" from either your O/S or by another job, simplest would be from a Server job because of the BASIC functions that do this. Check your online help for all of the DSGet* functions or the equivalents using dsjob from a command line script. Read about that in the Command Line Interface chapter of either Developer's Guide pdf.
Ramesh Kumar.M
Because of the way DataStage is architected, it is much easier to get job metadata using server routines. For parallel jobs the alternative is to write and integrate custom C programs which most sites do not have the skill to create, and are much more difficult to maintain.
Because there is no need to get job metadata in parallel, it is usually easier to write a custom routine in DataStage BASIC, then call it from a server job or sequencer.
Because there is no need to get job metadata in parallel, it is usually easier to write a custom routine in DataStage BASIC, then call it from a server job or sequencer.
Using Basic Trancformer In Px
chulett wrote:Isn't that what I said? You just used way more words, Andy.
(and nice sig, perhaps I should switch from silly quotes to titles, awards and my phone number, too) LOL
Thanks for all your suggestions, but when i am using Basic Transformer in Parallel Job the performance is very slow , more over the job is running panthom process for long time, please tell me if any special things to care while using basic transformer in PX, ie care on Partitions or any other things to do .
Thanks In advance.
Ramesh Kumar.M
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I do (understand the fear) but disagree totally with it.
The main issue, it seems to me from my experience, is the concern about needing to maintain two skill sets.
The main issue, it seems to me from my experience, is the concern about needing to maintain two skill sets.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Which is, of course, exactly what I meant. Totally disagree with the notion that they should be avoided at all costs, out of fear or skill set concerns or... what-knot.ray.wurlod wrote:I do (understand the fear) but disagree totally with it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers