DSXchange

Use a view or something to create a field without # in the name.

ps -ef | grep phantom

I would not put 30 jobs in one sequence. I would run in multiple sequences. Most of this is trial and error. You need to figure out how many jobs can run at the same time. The idea is keep the server at capacity without paging. Monitor your server. Usually some jobs have to run before others. Like a...

RT_LOG has basically a surrogate key. There is a field which stores the starting key for each run. It is stored in what is called a multivalued field. So it is not simple to extract the starting number and only list records which are between an old number and the next job run. I would try SQL if I w...

No. I have not tested it with version 8. Sorry.

This was one of the time consuming things I wanted to solve with Parameter Navigator. It includes a job which can match all these parameter names together. If you have twenty jobs with twenty parameters run by one sequence then there are 400 parameter values you need to fill out. PNav does a lot mor...

What are you using DataStage for? To convert from DBF to Oracle tables? Do you have existing jobs reading the DBF tables?

The application reading or writing to these tables makes no difference to DataStage.

I would substring it until it is close enough to use Oracle's to_date().

fareeda

We tend not answer questions which may look like a job interview question.

On server jobs you can retrieve them from logs.

It expects DataStage client to be loaded. DwNav uses information created by Reporting Assistant. It adds to this sequences but PX jobs and MVS jobs are not supported.

You can pass ' and = in job control. I doubt it would work in shell script.

I blame Ray alll the time too. Too busy to answer my questions.

There are lots of special characters which should be avoided in parameter values like = and '. You need to write job control if have to have these values passed in.

Download DataStageBackup.bat from my tips and tricks page.