DSXchange

We are Using Modify stage to add columns and also to add basic function like calculation in the derivation column but there is a binding error like syntax for the formulae ? So can we use the modify stage for that CAlculation.
pls highlight
Thanks
Yours
Sushanth

Probably not. As a general rule, transformations are performed in the Transformer stage (or in the BASIC Transformer stage).

Please describe exactly what you are trying to accomplish and where, and the exact error message generated and when (during compilation or at run time).

Hi,
When do we use a modify Stage anmd what are its features?
Apart from changing the data type droping or adding columns,
what else can we achieve through Modify Stage?

From the Parallel Job Developer's Guide:
The modify stage alters the record schema of its input data set. The modified data set is then output. You can drop or keep columns from the schema, or change the type of a column. (Emphasis mine.)

Hi,

According to Datastage Best Practices, Modify stage is the most effecient stage when compared to other PX stages. Modify stage is best used for explicit type conversion and null handling. If you want to do Implicit type conversion use the copy stage. But if you want more fuctionality other than these then you make use of the Transformer stage.

HTH
--Rich

Pride comes before a fall
Humility comes before honour

To only add new columns Column Generator is suitable.
But to add new column with derivation Transformer stage is suitable.
Using modifgy stage we can drop or Keep columns,Type_Conversions and Null Handlings.

Ex:to handle nulls:
col1=Handle_Null(col1,0)


Regards
Beeram