DSXchange

chill man. have you profiled your data? that error message seems to indicate a data/data tpye issue that's all.

you got to be careful when you try to mimic a DS lookup using joins within the database. DS lookup is a left outer join.

If you're on v8 then use the SCD stage. If you're on 7.5 you can use CDC stage. Not hard to template them up if you want to. I would use RCP if your environment can allow that.

which two columns are defined in your source? Is it Name and ID? What you want is to explicit define the columns you are sourcing and the columns you want into the target. Make sure that the datatype for these columns are exactly what is defined in the database. As the previous poster added make sur...

Maybe you have duplicate records and have turn on the option to remove dupes?

What is the meaning of the value 'R' in your field? You are trying to convert this value into a timestamp. So you need to put in the rule to handle this value before passing it on to the target stage as a timestamp. For instance you might decide to filter out all records with the value R in this fie...

Are the SQL queries look the same? You can use RCP in a generic job that can run all your queries.

Given that you are running Windows, I'd recommend put them into separate servers.

It's just a warning why worry about it? Sometime DS throw out warnings but so long as you are sure what you are doing then why worry about it?

You might have wrong version of the C++ compiler installed. Or you may need a patch for DS. Contact your IBM support. As to why your links don't change, is that phenomenon across all your jobs or just one job in particular? Once you set that environment variable to FALSE, make sure you close down yo...

Are you able to View Data in the DB2 API stage?
Did you specify the metadata for your tables?
Have you attended the Data Stage training course?

er..as suggested in the warning message which is to change your target field type to match your source field type?

Your error seems to indicate an bad installation. Try reinstalling DS.
MKS is the windows way of running unix.

Are you using Job Parameters? When you run the job do you change any of the job parameters? Perhaps when you do a view data you are just using Default values as specified in the Job parameters?

Hi,
What shell are you running? Try using Korn Shell (ksh).