DSXchange

I just found out that while the number of records from the rowgen stage can be parametrized , the cycle limit cannot be - so I guess you are better off knowing the cycle limit (max for now and for all of eternity ) in advance :) . I had used this logic earlier to multiply num rows and get a counter...

Elegant! I believe this is the solution I was looking for in v8.1. Thanks very much, rameshrr3! :D

Thanks again for your prompt reply, Mike.

Have a nice day.

Hong

I see. Thanks, Mike. If we developed such a BASIC routine, which would you recommend to implement it?

1) in a server job
2) in a BASIC Transformer stage in a px job

Do you think both are equivalent? Thanks.

Thanks, ArndW. So far I can see the value in col2 can be up to 108, so drawing 108 output links from a Transformer stage to cover all cases might not be wise. As Mike mentioned, implementing it in a Transformer stage that supports looping features would be the best approach for me, which will requir...

Thank you, Mike. The value in col2 could be between 1 and 108 as I see so far, and it could be larger which is not known in advance. A custom stage should be better but that would be costly for us as we are lack of such c programming skills in DataStage. If achieving this requirement in a server job...

What I can think of is to write an Unix shell script w/ a loop segment and wrap it into the PX job. Is there any alternatives? Thanks.

Dear All, I have a requirement asking for dynamically generating rows in a PX job. The number of rows to be generated is recorded in a column (col2) in the input link as below. Please share with me any of your thought on this as I didn't find a built-in stage that can directly handle this logic. Tha...

ray.wurlod wrote:I am running 8.5 on AIX. There is no Command stage. A search revealed only four objects with Command in their name:
Execute Command activity (for sequences).
A folder in the repository Data Elemen ...

Thank you for the alternatives, Ray.

Regards

If true then that's a change that no-one here has mentioned yet. I've only ever worked on UNIX servers so never seen the Command stage in my entire up-to-8.1 DataStage life. The fact that it can run 'UNIX scripts' could be simply because of the MKS Toolkit that is installed with the product. Ask yo...

I mean it's been available for the command in Unix in DS 8.5 as per the Information Centre. You can execute any command, including its arguments, that you can type to the shell of the operating system, such as Windows or UNIX . Examples include Perl scripts, DOS batch files, UNIX scripts , and other...

Thank you, Craig.

But it's saying it's been available in DS 8.5 as per the Information Center.

Hello All, We are in DataStage 8.5 now. As per the 8.5 Information Center, it's saying the Command Stage is able to be found in Processing category in Palette. But we didn't find this stage there. Here is the link about Command stage in 8.5 IC: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/...

Thanks Andy and Ray.

I found that the IBM Customer Service had ever provided a script called setowner.sh to fulfill this task before...

Not sure if anybody here know the content of this script and share it with me.

Thanks

Brian

Dear All, We have a case that requires to change current DataStage administrator id to others in order to facilitate a functional request. For example, the current DataStage administrator ID is dsadm (granted during DataStage installation), but we want to change it to another ID, like dsabc. After t...