DSXchange

Check for NULL values.

You can install DS on WinXP but you need Pro edition. It does not work on the home editon.

Try changing your fastname to your machine name.

I think a one example for each scenario will clarify your requirements. Maybe you will yourself find the solution that way.

No you can't. But you can select the non-Info type using the dsjob api or universe routines.

CRC32 is a 32 bit fn and CheckSum is a 16 bit fn. So CRC32 has more probability of returning different checksum values when the source is different.

If the problem is with your AIX Unix OS, I cannot see how upgrading DS will help.

You either need to upgrade the OS or use different method in DataStage to avoid the file growing to 2Gb.

But starting from step 1 will be a good guide to identify where the columns disappear.

Can you check whether the parameter is being passed correctly now. Maybe someone tampered with the job 'B' to remove the parameter.

Maybe you are calling the job in 2 different places or have any logic when deriving or passing the parameter.

You can still use the Basic Transformer stage to perform the 'if' clause.

But you cannot do a 'case' statement as it runs only on Server.

You have other features such in parallel but depends on whether you are using the condition for constraint or field derivation.

You may need to reindex your project.

It depends on what is in the tables.

You can use Oracle join to check it and return values.

Otherwise you can download them in a seq file and do an OS level comparison.

Search for unlock in this forum. There are lots of post which cover that point.

Make it a Binary Varchar.