DSXchange

I think it better to get the value dynamically in a job sequence and then pass that value as a parameter into the job.

What is the Shell script "dsjob" command?

Please surround your program with code tags to make it legible. You are calling this as an after-job subroutine from the job itself, so I doubt that the end timestamp contians a value. Put calls to "DSLogInfo()" in your program in order to debug which path it takes and why nothing appears in your ou...

The Routines\sdk has routines in the "KeyMgt" category that allow you to do this.

If you have the "same" partitioning, then a join will only go between like partitions; in most cases the data isn't formatted that way and it will lead to data loss during joins. An easy test is to run the same job with a 1-node and an n-node configuration and compare the outputs, if they are not id...

The transform stage c++ programs are hidden in the repository but they unfortunately don't contain any headers.

Yes, it will keep the same partitions - but you need to ensure that a join on Group 1 from DataSet 1 doesn't link to a value in Group 2 on another DataSet.

right-mouse click on the warning message in the director, then choose "Add rule to message handler" and continue from there.

Hello Saraswati and welcome to DSXchange. Yes, there are header files you need to include. The Advanced Parallel Developer's Guide has a chapter on the API. The file you need to include for DS function definitions is the $DSHOME/include/dsapi.h Now that I tried it I realized that the PX function def...

To complete the design - put in a transform stage that keeps a running total and compute the percentage rank there.

Pradkumar - I don't know which mainframe character set you have, so I just chose one at semi-random. Use any EBCDIC character set to test.

Nirmala84 - the same method of using stage variables applies.

Did you specify a block size of 1? Do you use a surrogate key stage in your job flow to actually generate keys?

I'd use the LEN() function as well. You know how long the numeric column is, when you convert from number to string and use LEN() and LEFT() functions to parse your result.

Sort the data on your key field, then use a transform stage that stores the last record key value in a stage variable and use the stage constraints to output records accordingly