DSXchange

In DataStage, you can do arith computations on char field as long as they hold numeric values.

You need SADD only for larger values.

This is because the library file librfccm.o is not in the datastage lib dir.

Right(YourString, 4)

Use conditional logic based on this.

Cast them as integer and perform the compulation.

You need to identify the row by any method such as row number.

Search the forum for more info.

No. You need to add logic of managing files to achieve that.

Make it string.

Did you try using stage variables?

Can you post your solution so others having similar requirement may find it useful.

You can use logic in DS. But unless it is from external connection to DS or included by some logic in DS, it is difficult to control and maintain.

You can use logic in transform to populate any of the 3 cols.

You can then use hash files to obtain them in one row.

Try Update EDU_AGG_T Set Imm_Row = 'N' where ACC_NO in (SELECT MAX(ACC_NO) ACC_NO_KEY from EDU_AGG_T ) Or if you want to add both the Acc_Key also, then try Update EDU_AGG_T Set Imm_Row = 'N' where (ACC_NO, ACC_KEY) in (SELECT MAX(ACC_NO) ACC_NO2, ACC_KEY from EDU...

Your inner-most SQL has 2 ACC_NO. Also it has 2 fields but the where clause attempts to match only one.

Duplicate post.

You need to post the SQL and the error message to get any useful response.