DSXchange

:?: Hi, In ur job ur useing sort stage then after remove dupilicate stage is useing can u remove the dupilicates in sort stage itself so u can try on that option then u may get....... As previously admonished, please strive for a professional standard of written English on DSXchange. What you have ...

There isn't one.

You have to derive it by whatever mechanism you prefer.

All DataStage job runs are independent of each other and therefore do not require any Session ID.

You need the correct JRE for Information Server - not something from Sun or Oracle. Involve your support provider if you can not find it yourself.

No.I want to duplicate the incoming row to n same output rows. My answer to your specific question is unchanged. To generate multiple output rows from a single input row use a Transformer stage with multiple outputs. See for example I have a job which collects statistics of the job. if there are 10...

Not possible in the CFF stage type. What you can do is create the maximum record definition and specify "create fillers". Better is to have "them" deliver you a consistent structure. Another possibility is to use Sequential File stage to read each line as a single string, and to ...

Right click in Monitor background area and enable "Show instances". Parallel stages will show as x 4 if collapsed, or as four separate instances if expanded.

And, of course, 0x1A is Ctrl-Z.

Format is not relevant to timestamp until you convert it to string. Timestamps are stored internally as nine byte structures. View Data does not have a format string, so performs a default conversion to string preserving as much information as possible.

By now (491 posts) you should realize that we need exact error messages. Without these we're wasting time guessing. Oh, and disable operator combination before capturing the error messages, so that you know from which actual operator they are being generated.

This is an internal limit on the length of a message, not anything to do with the data. I think that DataStage has somehow preserved as a "leftover" the original Decimal data type. Unfortunately (as you noted) the diagnostic technique to dump the schema is not suitable in this case.

Result = DSGetParamInfo(hJob, vParamName, DSJ.PARAMVALUE) Begin Case Case Result = DSJE.NOERROR * Yay! Case Result = DSJE.BADHANDLE * hJob is not a valid job handle Case Result = DSJE.BADPARAM * Parameter named vParamName does not exist in job Case Result = DSJE.BADTYPE * You've mis-typed DSJ.PARAM...

To generate multiple output rows from a single input row use a Transformer stage with multiple outputs. When you say "different data" do you mean "different metadata" (that is, different structure)? In a server job about the only way you can handle different metadata it to read t...

Download the correct JRE from IBM, like Martin advised.

Haven't installed it but, just from its sheer size (I have downloaded it ready to install) I'd say it is a roll-up.

You don't have to compile the jobs manually. Use the multi job compile utility. This can be applied to the result of a Where Used analysis applied to the shared container.