DSXchange

Yes.

But it's a DIY (do it yourself) solution. You need to extract events from the log tables and direct them to the file(s) in question.

An ideal mechanism would be a DataStage job! :D

Mod(DayNumber, 7) returns 0 for Sunday and 6 for Saturday where DayNumber is in DataStage internal format.

Applying that knowledge to the date you're testing and to the first day of the same month (see also MONTH.FIRST Transform) should give you an elegant solution.

There are three roles. Operator can only run released jobs. They can't even view all log entries unless this is allowed in the Administrator client. They can't modify jobs or metadata and therefore don't need Designer or Manager. Developers can modify jobs and metadata, and therefore can use Designe...

In Director reset the job and read the "from previous run..." message.

Also check the logged event that shows the actual SQL that is used; make sure that it is the same as you believe you have pasted in.

As Anand pointed out, a reference input link performs a "get row given key" function. The only way you can do this in SQL is using a WHERE clause so, when the DRS (or ODBC or any database stage type) serves a reference (lookup) input link, there is an automatically-generated WHERE clause in the SQL ...

Any browser in DataStage looks on the DataStage server machine. It can use any mechanism (such as samba) that you may have in place to view Windows folders from UNIX.

Otherwise you can use an FTP stage if your Windows machine can act as an FTP server.

Had you searched here, as advised, you would have found this URL

osh is the name of a shell, just like sh, csh, ksh. You can invoke it from UNIX, therefore you can invoke it from a Wrapper stage.

Same person, new nick? That's one way to get to 10,000 users!

how it will be used effectively in Datastage

The VOC file contains every word and token that can be used in that project, including table names, routines and lots more.

If it's not there, DataStage won't work at all in that project. That "effective" enough?

NEWACC isn't a file, it's a directory. Ordinarily it contains six files. If yours is truly empty, it suggests an incomplete installation.

You could possibly invoke it using a Wrapper stage. The important thing is to handle stdin and stdout properly.

There are no nulls in sequential files. Therefore the Format tab in a Sequential File stage allows you to specify how null is represented. By default a zero length string is interpreted as null. In the Columns grid you can specify a different representation of null for each particular column. But th...

When a new account (project) is created, the VOC file is created and its contents loaded from the NEWACC ("new account") file.

Then other structures are copied from the Template project (which does not have a VOC) and pointers to anything necessary are created in the VOC file in the new project.

I agree. Sometimes I use the job's user status area as a mechanism to pass back a value. Since routine arguments are passed by reference, you can alter their values in the routine and retrieve the results from the arguments. It's not recommended practice, but it does work. Remember to document a war...