DSXchange

As an academic exercise, you can also do this with two links, ordered correctly. Have your first output link from the transformer send only the YEAR column to an OCI stage. Constrain it so it only sends one row - the first row. Set the update action to 'delete' based on that single key field and set...

Unless I'm missing something here, you've named your parameter filename . That means that in the sequential file stage, you need to reference #filename# - not #file1# - in order to use this job parameter. A big clue that things are ok or not setup properly is, when you click 'View Data', does it pro...

Nope, sorry. Pretty much the IP of Ascential and not made available to the general public. Now, some folks here with years under their belts have 'hacked' into it and exposed parts. You'll see various routines posted here that take advantage of that knowledge. But in general, the answer still is no....

If the passwords are set as an Encrypted type in the job then their values will be encrypted in the job's log.

Your first problem is a known issue with parameter values. I've stopped trying to use quoted values in parameters a long time ago because of the fact that certain situations seem to strip them off. Best to not include them in the value, but include them when they are used. For example, rather than p...

It would probably also help to verify what you mean by 'scheduled'. Via Director? And therefore via 'cron' or 'at'? When you say you verified it in the schedule, does that mean you checked the crontab for the scheduling user? Also, when you say it 'picked wrong values', does that mean it used the de...

There's nothing to escalate. Everything is in the message that you posted. The branded ODBC drivers provided with DataStage are meant to be used by DataStage jobs, period. While you can code up some BASIC routines using BCI routines and the like, it will only work for 30 days - an evaluation period....

Could it be possible that the link.NOTFOUND function have a bug in datastage 6 Yes, it's certainly not out of the realm of possibility. Back in the day, before the NOTFOUND was added, the only way to check the success of a hash lookup was the IsNull function. When NOTFOUND was first introduced, I s...

The DataStage ftp stage calls the underlying FTP connection between your server and the remote machine. Hence it must be reliable. No, not really. There's one enormous difference between command line ftp and the FTP stage - the stage is metadata driven. It tries to process 'records' whereas ftp jus...

Of course... every 500 records plus when the stage 'finishes' normally a commit will be performed.

Also, from what I recall, the $500 dollar version of the online classes last 30 days. If you pay full price (in essence the same as the live class) then you have access to the material for one year.

At least that's how it was a few years ago when I priced it out for my compatriots.

I have a very strong sense of Deja Vu working right now. Didn't you post this very same question only a few days ago, Phil?

Not sure why this was posted twice, except it looks like one was meant to go in the PX forum. You might want to delete it. (never mind, too late for that) There's no easy answer... but there is an answer! This post has a way to do what you need to do in a hash, or can be adopted to do so. Hard to di...

ACtually, it sounds more like the SP2 bug. Tom, if indeed you do have Service Pack 2 installed, log onto the Ascential eServices website and download the patch. Certainly can't hurt.

Check this post for the 'readme' from the patch.

I believe you are going to find that changing all of your jobs is required. May not be as difficult as you think, however, but then I've never tried it myself. Export two jobs - one with an OCI stage and one with an OCI8 stage - in XML format. Carefully study the differences between the two stages i...