DSXchange

Adam Savage might (does) say "I reject your reality and substitute my own."

No.

You can certainly trigger a mainframe job using some kind of enterprise scheduler, and the parallel job can notify that (for example by creating a specific file) that the mainframe job needs to be started, but it is not possible to do so directly from a parallel or server job.

None of which I'm aware. However, if you study the SDK routines, you may get some clues as to the algorithms required in your own parallel routines.

I use the appropriate routine(s) for the task at hand.

This has meant that I spend some time studying what's available in the Repository of each new project on which I work, so that I can leverage anything they've already produced (as well, hopefully, as conforming with in-house standards).

It's dsjob (lower case, no trailing "s").

Show us what you did, where fix_zero is used. Did you really use fix_zero somewhere in DataStage TX, or have you posted in the wrong forum?

There is a "repository" on the server. However it is not a database; it is the "project", and contains (primarily) text files. This stems from the fact that INTEGRITY (the forerunner of QualityStage) began life as a mainframe application. That said, it is one way traffic. One develops on the client ...

There are some examples in IBM's class DataStage Essentials (Server Edition) about how to use the SDK routines to "translate" such data into character numeric (= human readable) form.

[quote="ajay by private email]I am not a premium member hence unable to see your complete message..I just want to append todays date to the file that i am moving to archival folder..i am able to move the file to that folder using the routine ...But i am unable to rename that file by appending the da...

First step is you telling us how you propose to detect - from UNIX - the change of state of the table in the holding area. Once you have advised that, then maybe we can proceed with further analysis.

Correct. It is not documented anywhere. That should tell you something.

The answer to your second question is "only if you have managed to discern the complete record structure used in DS_METADATA".

From the Administrator client's Command window:

ExecDOS is already written. I guess you mean that you want help with the DOS command for renaming a file. Set up job parameters with the required components, then use these in a RENAME command. For example:

A Batch, a job sequence or a user-written job control routine are all the same thing - the code can be viewed through the job properties. Therefore, all else being equal, there are no differences. Job sequences can indeed be invoked by third party schedulers, via the same interface (dsjob) that you ...

So do lots of folks. The first thing you need is a DataStage server installed on that UNIX platform. Do you have that? Once you have that, investigate the dsjob command.