timestamp

[sush26283]

Hi, I need to create a timestamp column in my target table (sql server), which will read data from source table (sql server) and datastage when run will create the timestamp on the target table. my question is while creating the column what has to be set as the attribute, datatype for the column.
might seem to be a simple question but am pretty new so, help will be appreciated.

thanks

[jwiles]

What is the datatype of the target column? If it is datetime or datetime2, I believe you would use the DataStage TimeStamp type.

Regards,

[qt_ky]

For datetime, try type,extended,length,precision = Timestamp,Microseconds,23,3.