Current Time from Column Generator

[sidharth]

Hi All,
I have a requirement where i need to update a field(LAST_UPDATE_TIME) in a table with the current timestamp, when a record gets updated. I can very well use a parallel transformer and use a CurrentTimestamp() function. But wanted to check if we can use any other stage to get this requirement done. Basically i am trying to avoid the usage of a transformer.
Is there a way we can generate a current timestamp (like sysdate) using a "Column Generator/Row Generator" Stage ? if yes, can you please let me know the parameters ? When i tried it gives the default date (1960-01-01). I am using a sequential file as source.

Thanks for the clarification.

-Sid

[ArndW]

Using the generation attributes will let you either cycle through a list of values or increment from a starting epoch, but won't give you the current date/time. You should use the transform stage for that derivation.

[ray.wurlod]

The Column Generator stage has the limitations that Arnd suggests. You need a different stage type downstream (probably a Transformer stage) to insert the current time value.

[goosarikiran]

Hi

it is not possible to assign the current timestamp in the column generator stage. But you can pass the hard coded time stamp (calling any routine and assigning the value to the parameter) using job parameter to the column generator stage. This may help you....


Kiran