DSXchange

You know, I started to reply in terms of record count, and somehow switched to maximum value. There should be no difficulty initializing a stage variable to 0 and adding 1 to it for each row processed, then summing and/or maxing these downstream after collecting onto a single stream.

Bad advice, not least because you can not simply delete entries from UV_SCHEMA and secondarily because a semi-colon terminator is required for each DataStage/SQL statement. And, third, UV.ACCOUNT is not accessible, by default, from the Administrator client without creating a pointer to it. Checking ...

You can find the maximum on each partition. This example is for integer. Initialize stage variable svMaxValue to -2147483648 (for VarChar initialize to ""). Then assign its value as If InLink.TheColumn > svMaxValue Then InLink.TheColumn Else svMaxValue Downstream in the job, you bring these partitio...

Why not use DSGetJobInfo() to get the parameter names and DSGetParamInfo() to get the parameter values?

If you insist on using the log, investigate the DSGetNewestLogId() function, in particular the InfoType argument to get a "Started" event.

Your time dimension table might have a column PREV_MONTH_DATE. Or, if it has monthly granularity and has been created with a surrogate key with an unbroken integer sequence, then you can take the key one smaller than that for the current month.

The rule of the other thumb is to have some smaller configuration files for running multiple small jobs at the same time.

The optimum solution is a time dimension table with month granularity.

You "heard" did you? Where?

Read what I wrote again (in both earlier posts on this thread). The answer to your most recent question is in there, if you give it some thought.

Project was incompletely deleted. Does it show up on the list of projects in attach dialogs? Does reference to the project appear in the UV_SCHEMA table?

CType or OLETYPE is the name of the class from which the object (stage, link, table definition, etc.) was instantiated. Try this query to get a list of job object class names. SELECT DISTINCT OLETYPE FROM DS_JOBOBJECTS; These are NOT stage names. Stage names are allocated automatically as stages are...

There seems to be a "." character on the end of the SERVICENAME entry. Can you please verify?

Leave off the redirection. The stage reads stdout of the filter command. If you redirect the stdout stream there is nothing for the stage to read.

Therefore you can even leave out the cat command, and specify the source file name in the sort command itself.

Except that UniVerse was first designed as an Application Development environment (more than just a database environment), I believe Ray's answer addresses all the points in your most recent post. If they don't, all the answers are to be found in the UniVerse documentation. Just be aware that few, i...

Does work?

Please post how this was Resolved. Obviously you found what it was that you did. But what was it?