Modify Stage

[ppp]

Hello,

I am trying to convert a column ACTIVEDATE from timestamp to string.
I have tried using the "StringToTimestamp" conversion function but am getting an error as below:

Code: Select all

main_program: Error parsing modify adapter: Error in binding: Error in destination field selector: Expected integer, got: ":"; input: 
ACTIVEDATE[:string] = [TimestampToString]ACTIVEDATE
;

[ray.wurlod]

Functions ...To... belong in the Transformer stage. Functions in the Modify stage mainly include ..._from_... for example Timestamp_from_String.

There are errors in the Parallel Job Developers Guide chapter on the Modify stage. The best reference for the Modify stage is the Orchestrate Operators Guide - this OEM manual does not ship with DataStage but should be available at no charge through your official support provider.