DSXchange

All Vince meant was that the 'conventional' DataStage constraint would use @FALSE to shut down a link. Much less confusing for peoples not intimately familiar with 0 and 1 and which is true and which is false.

Or at least that's my mind reading attempt for the morning.

If you get into a situation where you feel you may need to change the underlying RDBMS, there always the DRS or Dynamic Relational Stage. It was built for this very reason and allows you to shift from various native drivers to ODBC by setting a parameter. Not sure if it supports Informix natively, h...

Hello.

One would certainly hope so. Plus you should have more control over the various options available when working with your database of choice. Easy enough to test. Build two jobs, one with an ODBC stage and one with an Informix stage as the source. Have them select everything from the same large table...

I don't have any hands-on time with the Informix stage, but in my experience it's generally better to use a 'native' stage over something generic.

On the other hand, an ODBC wire driver can be used when you don't have the client software installed on the DataStage server.

Are your hash file direcotory paths supplied by job parameters? Are they being passed to the child job by the Sequencer?

If you are a member of ADN you can find it posted in their file library. From the GA annoucement there:

DataStage 7.5 is now Generally Available. I have placed a What's New in DataStage 7.5 document in the File Library, http://developernet.ascential.com/forum ... category=4.

Sorry, had to run one of our dogs to the emergency vet, or I would have expanded on this. You should be able to search the forums here and find some examples of full-featured scripts for handling the call to dsjob. We use the '-jobstatus' command line option so that the script waits for the job to c...

First off, why would you post in this particular forum? Since you've marked this as a PX question, it should be in the Enterprise forum. Perhaps the Powers That Be will move it. Secondly: Currently as per the Client requirement DataStage jobs are executed thru Shell Script. Now they want these are j...

There just so happens to be an entire thread on this very topic posted today! Short answer is you can't, but the linked thread has some workarounds.

Michael Hester has posted a nice CRC32 routine for DataStage. You can find the thread about it here and it links to where it lives in the Download section on ADN.

Exactly! I almost put something like that in my sig the other day after I saw yours.

Only other advice I can think of would be to work with a DBA during one of the 45 minute runs and see if you are hitting any locks or other problems in the database. I had a job yesterday that literally takes 5 seconds sit for 15 minutes waiting for access to a table it needed to truncate and rebuil...

Nice

Never thought to do something simple like that for testing. One too many Gargleblasters, I guess.

It would only need to be installed on the server. Assuming it is, then this kind of error is almost always an improperly configured dsenv file. Read the docs for the stage, especially the configuration requirements. Make any changes needed to the dsenv file and then stop/restart the DataStage server...