Generic stage used to Modify

accentureBB · Post by **accentureBB** » Wed May 12, 2004 8:18 pm

Trying to modify, getting 'Transformation: "modify" operator may not have a modify adapter on its output'
code looks like this:
modify
'
TXN_DATE= date_from_timestamp(TXN_DATE);
'
thanks for any help. (input is defined as timestamp, output as date).

ray.wurlod · Post by **ray.wurlod** » Wed May 12, 2004 9:12 pm

Welcome aboard! :D

The expression used a Transfomer stage is exactly that; an expression. It's not an assignment statement.
Get rid of the "TXN_DATE=".

The result of the expression is used to become the value of that particular column on the output link.

Use the expression editor to build expressions, it saves typing errors and it saves incorrect assumptions being made.

accentureBB · Post by **accentureBB** » Sun May 16, 2004 4:58 pm

I'm in a Generic stage, using the modify operator. I'm not in a Transformer, if that's what you were referring to. To get around that first one I changed my job. But I've run in to the same error again, so would like to solve this thing. I've looked at some Ascential documentation but hasn't shed any light. The latest error is this:
main_program: Transformation: "modify" operator may not have a modify adapter on its output
and the modify i'm performing in the generic stage says this:
modify 'AMOUNT:int32=AMOUNT;'
I'd greatly appreciate any insight. Thanks.