DSXchange

kumar_s wrote:Version 8 is available in market already for widows as of now.
So you can expect the same functionality in Unix soon.

Widows?!!

Ladies, don't rush out and kill your husbands just to get your hands on a copy of version 8.0.

For the UNIX versions, it's more likely to be months than weeks.

No matter what you do you're going to need to move the file from the mainframe to your DataStage server. Why not have the mainframe push the file across and then read it with a Complex Flat File stage, which is intended for use with COBOL file definitions, handling level numbers according to your re...

On a point of efficiency, you've calculated Field(Input.Field, " ", 2) twice. It would therefore be better to calculate this in a stage variable. Once.

Is dsrpcd actually running? Use ps -ef | grep dsrpcd | grep -v grep to find out. Ah, yes, you did; I see it at the end of your post. This daemon should be automatically started, as part of starting DataStage; you ought not to have to start it manually. If you do, I believe it's better to be root to ...

I should have thought of that. One of the very first things you do in ProfileStage diagnosis is to check the logs, particularly for message switch activity.

Please mark the thread as resolved.

Coding from memory! Have edited code.

Select fDSJobs To 9

DSJS.RUNFAILED

Sure you do. razor.

The best document is the class notes from the Advanced DataStage class from IBM (DX436) or the Advanced Parallel Job Techniques class from me.

Right mouse click on the Routine activity. You should be able to open the Routine by that means.

For advanced runtime options open any parallel job, open its job properties and find the Execution tab. Then click Help.

The Modify stage has a function called handle_null() for replacing an out of band null (the NULL you're talking about) with a specific value (an in-band null). It also has a function called make_null() for generating an out of band null. So perhaps you could try: NewCol=handle_null(make_null(...

Does PATH contain $PXHOME/bin ?

Not only that, it's also necessary for correct function of the Oracle Enterprise stage. So you must demand these SELECT privileges.

You probably do not have write permission or appropriate privileges to the DS_LICENSE table, which indicates an improper server installation or someone fiddling with the permissions.

The Transformer stage would not be the appropriate stage type in any case; you would use an Aggregator stage to aggregate the data in this fashion. Sort the data as they are extracted, and use Sort method in the Aggregator stage. Or do the aggregations as part of the extraction (which means that you...