DSXchange

Let us assume you can have 1, 2 or 3 days difference. In you transform stage have one output link with the constraint DaysDiff<2 , one with Day sDiff<3 and another with DaysDiff<4 . Each of these three links go to a link collector. When you have 2 days difference, the first two constraints will prod...

Pramod, I am surprised that the parameters you have chosen, since they are not the usual suspects when it comes to job tuning. If you use a lot of hashed files then you should increase your UVCONFIG values for MFILES and T30FILES (double or triple them). This will increase the rotating file pool and...

Noam,

I'm sorry but I have to admit that I don't recall.

Kris, I can't see which line in the code you posted might be causing the invalid datatype error. The line number that the compiler thinks is at fault is often not correct, this is due to a limitation in the compiler (this problem has been around since over 20 years!). If you've done this much work a...

...I dont understand why there are so many features missing in DS7.1... :D I've never looked at software improvements that way, I prefer to view it as "look at all the nice things they put in the new version that we didn't have before". It's like wondering why those people at Ford were so silly as ...

Pedro, setting the uvconfig value for 64 bit files to 1 means that any and all files created thereafter are going to be 64bit. This will mean that all of the hundreds of small hashed files that make up your projects and jobs are going to be use the bigger file pointers that are slower. It is general...

The error is not in your sequence, but in one the PX jobs which it calls. Can you isolate that job? Can you run any PX jobs at all? If not, then the error message is most likely accurate and you need to look at the setup on your remote (presumably the database) machine. Can you rsh as that user to t...

Where are you doing your "select"? Are you selecting the job in the Designer while making a sequence, or in the display screen of the Director or Manager?

Andy,

libraries are still missing. If you run a job and look at the first output in the director log it will display the processes' ENVironment. The LIBPATH should contain a path to your Oracle libraries as lstsaur has already noticed.

The ODBC access to Informix in server has always been faster. It seems that the ODBC drivers were written by what is now DirectConnect using very fast and efficient APIs that surpassed the performance of the direct informix drivers. I was not aware that this also applied to the PX calls and am more ...

You haven't stated where your data is coming from. Is it a text file or a database? DataStage will not just strip one character from this string; so I would use a hex display editor if the source is a flat file or the substring functions in your query language directly to make 100% of the field leng...

If your maximum number of days difference is some manageable amount (i.e. about one month), then you can have a transform or switch stage and use the value you calculate for days to specify output rows, then later on in the job collect those rows back to a single stream. This is the simplest way of ...

Good Job! I didn't want to recommend changing you DS settings since I dind't know what else might be affected, but I'm glad you solved it by yourself!

Most likely the entry is missing in the dsenv shell script.

Can you check your dsenv file and ensure that the LIBPATH includes the ..../PXEngine/lib directory?

the windows scripting language for .BAT files is quite primitive and doesn't offer even close to the functionality of shell scripts in UNIX. I think that you might be best served by installing something like MKS Toolkit which will let you run unix scripts within Windows.