DSXchange

Can you please purchase a premium membership, so that you can see my solution (and help to keep DSXchange alive)?

How do you know when one of these feeds is ready? That is, what would trigger DataStage processing?

Fmt() is not available in parallel jobs. Had you bothered to Search you would have discovered that it's even easier than your "solution". Assuming you require a seven-character wide result with leading zeroes, use something like Right(("0000000" : OutAgg.QTY), 7) The inner ...

There should be a group to which all DataStage users belong and that is used to give access to the software. This group is ideally separate from the group that is associated with a project. Except as required by the operating system the dsadm user does not need to belong to any particular group (but...

And was any record in fact provided to the stage on node #1? If you only provided one record in your design, then it was unwise to run that stage on more than one node.

The answer to your original question is Yes. What you should do is simply to design your jobs do to precisely what is required.

You don't need Perl - any sensible programming language (including DataStage BASIC) can be used. Be aware that V0 is not the only possibility - for example if containers form part of the job design you will get V1, V2, and so on. And if there are shared containers an additional level of complexity i...

You could use DayFromDate() to get the day number and DateFromDaysSince() to get the new date.

Precedence is "most recent actually set". If NLS map name is set in the project but not in the job or stage, then the setting from the project takes effect. If NLS map name is actually set in the job properties (that is, is not set to "project default"), and is not overridden in a particular stage, ...

I f you run from Designer you must explicitly set the Warnings limit on the Limits tab.

I f you run from Designer you must explicitly set the Warnings limit on the Limits tab.

Data types float and dfloat can not be stored accurately in digital computers. Stick with Decimal or Numeric as the data type.

Does the sqlhosts file have a line terminator at the end of its last line?

Can you please post the actual error message? I suspect that this is a DB2 restriction rather than a DataStage one; your DBA may therefore be able to assist.

Welcome aboard.

Yes there is. Did you Search for the answer?