DSXchange

HI,
THIS IS THE REQUIREMENT:

I WANT END-TIME WHERE
END-TIME(TIME) = START-TIME(TIME)+DURATION(TIME)

IN PARELLEL JOBS HOW I CAN SOLVE THIS?

Hello Murali,

(uppercase posts mean that YOU ARE SHOUTING, we are not hard of hearing and can understand lowercase quite well)

Your requirement is common, but the answer depends upon your actual column definitions, as DataStage PX is very type sensitive.

I will assume that you have two columns, STARTTIME and DURATION; but what data types are they and what data type do you wish your ENDTIME to be in?

Hi,

Use the TimestampFromSecondsSince(seconds,timestamp) function. Note that here you can put number of seconds in negative value as well.

Sudarshan