DSXchange

Nope.

Hmm... an airport lounge drive-by. Technically, your answer is that you can check any one of the input links to the hash file to accomplish the task of clearing of it. When a job starts but before any rows start to flow through it, DataStage checks for conditions of that nature in the stages - trunc...

I am trying to call a stored procedure from a Oracle 8 stage. I know it cannot be done. Actually, it can be done. It is unsupported and has several limitations, but it can be made to work. See this thread for one example. You could also execute this by wrapping a script/batch around a call to SQL*P...

Let's see... 1) Don't know anything about TANDEM. If there are ODBC drivers for it, preferrably wire drivers so you don't need any client software, then the answer would be yes. Otherwise... [shrug] 2) Too many variables to answer that. You'll have to let us know how long it takes on your system. 3)...

Well... I know how I'd do in on a UNIX box but I'm not sure if there are Windows equivalents to the commands I routinely use. Perhaps someone with better batch skills could help out? Typically, I would strip the extension from the filename, and then add the date stamp and the new extension during th...

Well, seems like you have a couple of choices: Have the batch file get the current date and use that it when it creates the copy of the file. I know how to do all of that in a UNIX korn shell script, 'fraid I can't be much help when it comes to coding it in a batch file. Have a Job Parameter with th...

You need to go back, edit your post and use the "Code" tags to preserve the formatting that used to be there. It's very hard to following without that. That being said, I don't see any way for your loop to end. Somewhere between the Loop and the Repeat, you need an Exit. Or add an Until or While con...

You have to put "back ticks" around the cat command:

I can't really say specifically for the QS Stage (don't have it), but it is "good practice" to never link two passive stages directly together. I encourage people I mentor as a matter of course to always put a Transformer between passive stages like you mention, even if it "doesn't do anything" but ...

Create a Hash File lookup from the Oracle table. You'll have to stream in all the records from the AS400 and then when the lookup fails, that is the equivalent of the 'not exists' clause. There's supposed to be a new stage in 7.1 that allows you to connect to multiple database types... where's that ...

If your goal is to emulate the behaviour of a SQL Lookup using "between" you might want to check out this post by the ever popular Mr Kenneth Bland. It describes an alternate methodolgy to do what (I believe) you are trying to do.

the Datastage version we're using does'nt support connection to Oracle 9i thru OCI stage. We're using version 5.2. I think this a limitation of the agreement between our company and Ascential. Are you sure? Have you actually tried it? In the past, I've very happily used older versions of DataStage ...

Silly question perhaps, but why aren't you using the OCI stages to access Oracle?

A quick followup on this topic as I've gotten to a point where I need to install DataStage on a server with too many CPUs on it. Turns out DataStage will install, but you do get a Warning during the installation process that you have exceeded the license count. Everything is running rather nicely - ...

At my old company we had DataStage running under cluster control on a Compaq Tru64 Cluster. This didn't allow "load balancing" because it was only running on any one node at a time, but with shared storage it could be failed over to any other node without manual intervention.