DSXchange

It will only be 'fixed within a job' if you use the Sytem Variable in the Initial Value of the stage variable, otherwise it will be evaluated for each record. That and leave the derivation in the Transformer empty.

What about the explain plan? Is it the same when checked, Toad run versus DataStage run?

In other words, the 'path' is what the FTP stage will attempt to 'cd' to before the put/get is issued for the 'filename'.

You cannot. What kind of files are you reading? You may need to loop through them or concatenate them together before processing.

It doesn't need to be 100% to cause this error, just 'busy enough' to cause the job to take longer than the timeout value to start. And from what I recall, that value is 60 secods.

Just want to double-check that you actually need the 'read only' routines in the extract. Typically what are being excluded are the core routines that ship with the product and exist in every 'empty' project when it is first created.

The repository itself isn't published, but you can query the forums here for DS_JOBS and DS_JOBOBJECTS to find some examples of the kind of information available in it.

I'm curious why you are asking... what are you trying to accomplish?

Once it has been added to the job and is thus active in the job's environment, does it really need to be 'passed' to the routine?

Great, let us know how it turns out!

ps. It helps if you actually ask a question. Or state a problem. Or both.

It's not.

What kind of problems? I doubt you'll be able to use encrypted values with a technique like this.

Let me make an assumption here that the db name is part of the variable name. Put the pieces together and 'echo' the result: echo $#P_DB_NAME#_USER echo $#P_DB_NAME#_PWD Two Execute Command stages or a custom routine called in two Routine Activity stages. I'd probably prefer the latter as you have m...

And how do you plan on doing that? Meaning, how will the database name tell you which username and pwd environment variable to get?

Doesn't need to be 'user defined' to utilize a job parameter.