DSXchange

Look for rsh.

Did you check whether people are logged into MetaStage when you do this?

I agree with ArndW. The agg stage is best doing its job alone.

If all you want is to pass the input columns to output link columns, then you need not store in the parameter. Just link them to pass through.

Need more info. What kind of transformations you want?

Because you can flatten the multivalued fields in DataStage. But that will be based on the actions you wish to do in the fields.

Do think in separate links.

Use ds date.

You can reference the SQL server table itself.

Write the result in a seq file. That will give you an idea of what is being passed into the target.

Roy,

From my experience, the mf people do not mind ftp-ing files to mf as they can manage better than Unix or Win.

Why can't you use a batch file? A solution given in this site is based upon the information you provide.

You can join them in source and use conditional logic before populating target.

But how do you wish to identify a 'change' in the tables?

Did you create new hash files in both cases or was it the same hash file reused?

That is the parameter value passed to the BAPI stage.

You can pass your source link value to the target to retain mixed case.