DSXchange

It was the darn typo on my end. Meant to say "Who locked it" but instead said, "who unlocked it"

No. It wont tell who unlocked. Just tells you who initiated the thread.

User Id tells you that.

Yup. It sure will.

Ok you got me. If the count starts from 0 then yes. Darn you Kumar

kumar_s wrote:contraint to avoid KeyChange < 100,

Someone forgot the '=' along with '<'

Nice to know, I did not know we had a way to find out "Who unlocked the job". I dont have access to Datastage right now, need to look into that feature. And in the DataStage admin, you can type LIST.READU to pull up the same info. Even that will give you a list of all the live/locked threads along ...

O yea, forgot to add that. Thanks kumar.

If a job was locked under your id, someone else cannot get rid of it. Only you have to go in with your id and unlock it. "Who unlocked the job" can also be determined in the present versions by going into the cleanup resources and bringing up current active threads. It will tell you the id right the...

The OP wants only first 100 enteries per group. This would require a counter in a transformer to constraint the output to the first 100 per group. Then pass it through the aggregator to do the rollup.
That was my understanding.

Sorting is easy. Either an OS level or sort stage would do.
Do a group comparison of present row with previous row. If same start a counter.
In the transformer, restrict counter <= 1000. Then pass it through the aggregator and do your rollup.

If you got your issue resolved, you can rate the answers accordingly and mark the post as resolved.

The output is in the form of a dynamic array with other contents in it. They are seperated by a field marker (@FM). We are only concerned with the contents of the first field. The first code in my previous post extracts everything before the first @FM. The second code extracts the contents of the fi...

Inside the jobactivity, where your specifying $CommandOutput, provide the following

OR simply

What is the number in the file?
When you did 'type yourfilename' from the dos prompt, what did you see, did you see the contents of your file?
What have you set the parameter type in your second job? Is it set as string?