DSXchange

Please help ..its urgent This is not the correct forum for urgent queries. Rather you should sign up for premium service with your official support provider, and get a service level agreement that matches your "urgency" requirement. And thereby learn how expensive "urgent" is. D...

Perhaps the other projects are using not only the default configuration file but also the default configuration file location, $DSHOME/../Configurations.

Verify (in the "job starting" event in the job log) the value of the $APT_CONFIG_FILE environment variable for each project.

Check the file. It appears that "|" is not the delimiter or, if it is, that you have not specified this as the field delimiter property in the format properties of your Sequential File stage.

Ten rows were not enough to hit the 100000 byte barrier.

It's probably sufficient to enable Unicode as the extended property of that particular column. Make sure that it's defined in Oracle as CHAR(65) CHARACTERS (not BYTES).

Why not pass hard-coded replacement values (pathnames of configuration files) to the jobs in the Job activities that invoke them?

sendmkpk wrote:Well no offense ofcourse, that's the way we doing everywhere

Then don't even bother to apply to work on any project I'm running.

How are your data organised? In particular,does the Contacts table have one row per Person/Company combination? If so, you can pretty much use an exact match (or UNCERT if there are likely to be spelling errors) based on Company.

Perhaps I should have admitted to a personal bias, since I was there at the gestation and birth of DataStage!

There's a neat way of solving this with a server function:
but I'm not aware of an equivalent parallel function, so would recommend If..Then..Else for parallel jobs.

Literals in DataStage/SQL must be contained within single quotes. Try this Ans = "" svName = "pxHtttlemp" svTrimName = Trim (svName,".","A") svFMName = Trim (svTrimName,@FM,"A") *Get list of jobids that contains a SearchString cmd = \SELECT DS_JOBS.N...

Welcome aboard. Analysis results can be "published", which means they can be placed into the common metadata repository and accessed by other tools in the suite such as DataStage. To make analysis results available to other tools you can either read directly from the analysis database (for...

In my opinion DataStage has substantially more functionality than ODI. As you point out (and I admit not being able to comment cogently) ODI seems to be limited to what can be done in SQL, so no parsing XML, no invoking web services, no access to Java classes, no restructuring vectors/arrays, no del...

Since you're not the original poster - and unlikely to have exactly the same environment - why not begin a new thread in which you explain YOUR job design?

Which part of "Sequential" was unclear?

Right(InLink.TheString,4) would be easiest.