DSGetParamInfo

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No. I suspect the target table. Make a copy of the job with a Sequential File as the target. What rate do you get from that?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

In transformer 'job parameters' are recognized by thier name alone (No hashes or quotes around). You can avoid making a call to 'DSGetParamInfo' that way. Tho this doesn't seem to be the real reason :wink:
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: DSGetParamInfo

Post by chulett »

dsxbamboo wrote:Did I do anything wrong?
Yes. As noted, you are using an 'external' function internally. There's no need for it and it may very well be unnecessarily slowing things down.

Replace your function call in the derivation with simply FileDate and see if things speed up again. Derivations are one of those places where enclosing hash/pound signs around job parameters are not needed.
-craig

"You can never have too many knives" -- Logan Nine Fingers
dsxbamboo
Premium Member
Premium Member
Posts: 20
Joined: Sun Jan 14, 2007 3:52 pm

Post by dsxbamboo »

Thanks all for your help! This issue is resolved!
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

Post by Minhajuddin »

Can you post, How you got it solved?. That would help future searches. :D
Minhajuddin

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
Post Reply