DSXchange

It's in the registry. You should be able to find entries for everything that shows up in the Host System dropdown under:

HKEY_CURRENT_USER\Software\Ascential Software\DataStage Client\Director\

One entry per host name or IP.

It's not a problem with your sql, per se. It's a mismatch between the sql, the column definitions in the stage and/or what DataStage is expecting. This really only becomes an issue when you use custom SQL. Make sure you have the same number of columns defined in the stage that you are selecting - in...

Unfortunately Gaurav, datastage doesnt point out the column for which its giving error. Actually, it's Oracle that doesn't always point it out. Seems to be dependant on the Client version. Since the message is about precision, then as noted it only applies to the numeric fields. You get to check ea...

talk2shaanc wrote:Hey, craig i didnt get you. You mean to say it cannot be accomplished?

You got me. As others are pointing out, it cannot be accomplished. Transformer to transformer, yes - with the caveats about row buffering. Transformer to After-Job routine, no.

Me48, a couple of points: You don't need to check the results of an IsNull() call against 0 or 1, even though that will work. Being a boolean, it is easier to read if you just say If IsNull(INPUTLINK.COLA) to see if COLA is a null -or- If Not(IsNull(INPUTLINK.COLA)) to see if COLA is not null You do...

Beat Ray to the punch on that one!

They are right, all you need to do is define a stage variable - even if you don't use it - it needs to be there so the job will compile.

talk2shaanc wrote:My actual requirement is: Intialize it in one of the transformer and use it in after-job routine of the same job.

You can't. That's quite different from initializing in one transformer and using in anther.

Sounds like you should be fine without using either of the Conv brothers, as you are bringing the field in already formatted as the DRS stage is expecting to see it. Any chance you are shortening the field inside the job somewhere? Perhaps a debugging session - or simply writting your target rows to...

In addition to above I wud like to mention that it is a RTI compliant job with RTI input and RTI output stages. Yikes! That's a pretty important piece of information to leave out. As mentioned, though, this could still be done in one job. In the Server forum you get server answers. I'd suggest repo...

pandu80 wrote:It accepts Coma,Space and Other. In the other can i directly specify "|" as delmiter

Yes.

Three answers: 1. Custom trigger code to send down your Ok link when the job finishes with a $JobStatus of 1 or 2. 2. Have your Ok link set to 'Otherwise' so that aborts go down your failure link and everything else goes down the ok link. Dangerous as things can fail with more than just an 'Abort' s...

The fun part is the "not mentioned in the input file" part. I'd suggest two jobs or at least two 'steps' which you could put all in one job if desired. The first to parse the XML and load the userids from it into a work/temp table in your database. Then a second to do your SQL join and extract where...

You should be able to find that information from the Help button inside the stage, I would think. Short version: Array Size is the number of rows read or written at any one time. Properly setting it can improve performance. In other words, an 'array' of records of that size is passed down the link a...

Use a script/bat before job to concatenate them all together, then process the concatenated file.