DSXchange

Spend some time learning about DataStage's date conversion functions. The paper Date Conversion Demystified is a good place to start. Search the Forum; there are answers to your exact requirement to be found. Essentially you convert the incoming date into DataStage internal format, then convert that...

Beware, though, that not all email addresses have a three digit suffix. We've had .co.uk (and other countries) since day 1, and now .info and .name (and .tv and the like) are becoming more popular. If you need to use the MATCHES operator against a list of possibilities, there's a cute trick using a ...

You've moved way off topic! In general you don't use hashed files in PX, and your post indicates that you want to perform a lookup in PX. Ideally, post the question on the PX forum. Basically, though, you no longer create a composite key - that's purely for hashed file. Instead, you declare as many ...

Search the Forum. I posted this eons ago. The easiest way is to use a CAST - VARCHAR(36) if you don't want quotes, VARCHAR(38) if you do want quotes.

Whatever you can do in TOAD or sqlplus you can do with user-defined SQL in DataStage. The question is how do you detect the requirement. When you're using TOAD or sqlplus you're doing this in your head. You need to introspect and convert the decision-making process into an algorithm that you can imp...

There is a table in DataStage called SYS.MESSAGE, in which many (but not all) of the error codes exist. This uses six-digit keys, so to find 81002 your query would need to add a leading zero, and use a character string. SELECT * FROM SYS.MESSAGE WHERE @ID = '081002'; The best other sources of error ...

You are looking at only part of the story. There are three kinds of routine, transform functions and before/after subroutines, which live in the Routines branch, and job control routines, which live within the job. A transform function is intended to be executed every row. It should therefore be as ...

RTI Services allows you to expose a DataStage job as a web service with real-time response. Often the DataStage job will incorporate one or more QualityStage components, for fuzzy matching and best-record survivorship. Imagine you have a DataStage job that processes a row of data to produce a change...

I don't have a problem with Ascential funding DSX. But I do have a major problem with them assuming that this would buy editorial or any other form of control.

Please post this on the DataStage server jobs forum.

Then search for "Excel". It's been discussed on a number of occasions before.

Do you really have Excel spreadsheets on your UNIX server?

These guys put out a CD of the best their site has to offer, which you can buy on line.

Small correction. It is possible to have hashed files shared between jobs. Enable this using the Enable hashed file cache sharing check box in job properties. This assumes version 7.1, and that you have enabled shared cache for DataStage hashed files. However, the assertion in my previous post on th...

SETFILE to create a pointer to the hashed file. Then get count as if the hashed file were local. You can use CLEAR.FILE to clear the hashed file. You can use DELETE.FILE to delete the VOC entry created by SETFILE but it will not remove the actual hashed file. To remove the remote hashed file use ope...

You begin by posting the quesion in the appropriate Forum. Why would you expect the Editor to know this?

You begin by posting the quesion in the appropriate Forum. Why would you expect the Editor to know this?