DSXchange

New (and completely unrelated) problem = new post.

ds_raman wrote:Thanks but i need to route the recors to Error Link, so i have to make use of StageVariables

No, you don't have to use stage variables. You can use your null check directly in the constraint that 'routes' the records.

I havent installed db2 client in aix machine, i have it on windows machine. Since i have it on windows machine, will i be not able to view the database in the server? Yes, you will not be able to. Since db2 client is installed on windows machine, i will be having db2 driver, so using that, i will n...

ray.wurlod wrote:There is no single "exact difference", in the same way that there's no exact difference between chalk and cheese.

I've had some cheeses that... well, never mind.

Yah, usually helps to read the documentation.

2ksaint wrote:Do i also need to install DB2 client in the Server

Yes.

"hi ray"?

There's more than one person answering questions here. I know it doesn't seem like it at times, but take my word for it, there is.

Ok, good to know. You'd be surprised how many people have the 'same problem' as someone else that turns out to be not all that same after all.

Just how "same" is your same? Version 8.x? Sequential source? RCP? SQLServer 2005?

and col1 starts with 'A' or 'B' is not valid syntax. You need to mention both sides of the expression each time, so if you want to stick with this methodology, you'd need to adjust it to: and (col1 starts with 'A' or col1 starts with 'B') That's valid psuedo-code, you'd need to use either t...

As far as I know, you must install an Oracle client on the same server as DataStage, you cannot have it on a remote server and then reference the UNC path and expect it to work.

Short answer:

Exactly, it's very cool when it all clicks for you. You then leave the derivation blank in the Transformer so that the value stays static over the course of the run.

No - Ken is suggesting the work be done in the Initial Value section of the stage variable's definition, which means it will only happen once per run.

Since there is no dsenv file on a Windows server, you'll need to create it via the Administrator client.