DSXchange

Hi, does a sequencer stage do the trick as well? Roy, A single sequencer (after the last UVA but before the Job Activity) does not. Neither does putting a sequencer between each UVA. I can't hook the UVAs up in parallel to a single sequencer because of the dependencies of the variables within them....

Hello, Does anyone know how DataStage executes a series of User Variable Activities (UVAs)? I'm having a problem wherein a series of three UVAs do not produce the same output values to a subsequent Job Activity from run to run. The first UVA loads some environmental variables via $PROJDEF and then o...

ArndW,

Auto-partitioned all the way. Still scratching my head over this one, but not for too long...

The good news is that I restructured my job due to a requirements change and the error went away. The bad news is that I don't know why - I made several changes and although the design is not that much different from the original, I could not deduce what would have caused or eliminated the error. Oh...

Hello, I'm getting this rather nondescriptive one-line fatal error message out of a transformer stage: Operator initialization: Input port 0 already connected; text: 0< 'Restructure_to_V3_SLH:V3_SLH.v' The transformer has an input (V3_SLH) from a copy stage (Restructure_to_V3_SLH.) The copy stage is...

Well, it looks like this one will remain a mystery :? The problem must have been specific to the particular function I was testing the code snippet in, because this morning I cut and pasted my own code into a different routine and ... no problem. Unfortunately, I no longer have the piece of code tha...

I've tried the following in a Server routine intended for use in a PX sequence: S = '"ABCD"' ; * That's '-"-ABCD-"-' T = S[Len(S)-1] ; * T = ABCD" at this point U = T[1,Len(T)-1] ; * U should = ABCD V = T[1,Len(T)] ; * V should = ABCD" Now when I run this code, string V...

This particular problem arose because the DB2 stored procedure in question had both input parameters and an output cursor.

Ascential has provided me with a solution in the form of a patch for version 7.5.1. Refer to ECASE G73450 on the Ascential support site for more details.

tpb

Ascential support has provided a workaround for this issue. The solution is to enclose command line arguments passed by the wrapper as "Value Only" in a set of double and single quotes when specifying the wrapped stage properties. For example, "'arg1'". Parameters passed by the w...

The String to Integer conversion does not seem to work in 7.5:

Numeric string expected for input column

is the error message received from the transform. The problem seems to be with the '0x' prefix - I can't even get AsInteger("0x00ab") to work.

And when you migrate your job with that environment variable to other platforms or projects that have different values, your job still have the default value preserved -- over-riding what the project/system/universe/everything/42 values are. This is why I advise all of my clients to not rely on pro...

Thanks, those are informative comments. But back to my original scenario, then: For example, suppose I would like to run a DS job early every morning that would set a user-defined environment variable, $COLOROFTHEDAY, dependent on the forecast high temperature read from an XML file obtained from an ...

Ray, I can start Designer, open a job, create a new environment variable, close the job and exit from Designer. Later, I can go back into Designer, edit another job in the same project as before, and have access to the same environment variable. This seems to indicate some sort of persistence at a l...

Follow-on question: Is it possible to update a project-wide environment variable from within a job or sequence? For example, suppose I would like to run a DS job early every morning that would set a user-defined environment variable, $COLOROFTHEDAY, dependent on the forecast high temperature read fr...

I'm trying to pass some command line arguments to a UNIX command through a Wrapped stage. I'm having difficulty passing a variable String value that normally would be enclosed in double quotes if it were typed in at the command line. Think of a string with whitespace and/or special characters. When ...