DSXchange

Nobody, not even the OP, has addressed how the time component has to be created.

022 is not enough if you want to run jobs saved/compiled by another user, because you will not be able to write to the job logs. The alternative is to set the setgid bit on the project directory. This will only affect subsequently-created objects, so should be done immediately the project is created.

SET.TERM.TYPE VT100 WIDTH 80 DEPTH 24 Make sure that your terminal emulator is emulating a VT100. If not, substitute the relevant terminal type in the SET.TERM.TYPE command, which tells "UniVerse" what terminal type is connected to it. The initial terminal type is set from the TERM enviro...

What do you mean by "running"? What are the indicators that the job is still "running"? Does the job eventually finish?

It is. The one-node behaviour (start processing one message once the next arrives) is being replicated eight ways.

Try this UNIX command and see it you run into a problem. There may be an operating system limit on the size of a list.

What DID you use in the constraints?

Does your Transformer stage have an Otherwise/Log output and/or a Rejects output link?

Let's start by asking for the business definition of "Fiscal Year" where you are. Is it July-June, May-April, or something else? Obviously that will affect the solution. The others are easy using functions such as year from date. Fiscal year and fiscal quarter are derived from calendar yea...

Moderator: please move to server forum

Correct terminology is HASHED file, not hash file.

... and run away!

I assumed you'd released the lock from within the database. DataStage doesn't have any way natively to do this, but you could issue the relevant DDL statement in a Before SQL command of a stage in a job that does nothing else.

Use a combination of ls -lrt and tail commands to get the latest entry from each directory then use sort.

Yes I know these are UNIX commands and you're on Windows, but you will find that you have UNIX commands available via MKS Toolkit.

If you're running the job from a sequence, use "reset if required, then run".

Where are you doing your logging? (What are the values of RTLogging and ORLogging in DSParams?)

Don't know. Do the latest ODBC drivers offer support for cubes?

Presumably user-defined SQL can include cube-extensions such as references to dimensions.