Originally posted by: SystemAdmin

Hi Guys,
I am planning to archieve(taking the backup) the output file based on the TimeStamp(The time has to be appended to the end of the archieve file.

I am able to archieve the file but unable to append the TimeStamp.

Please, help me out from this situation.

Will be waiting for your reply... :)
With Regds,
Sandeep.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: jvanboga

try posting an example of your command. Should be able to use something like fromdatetime(currenttime(), time_format).

Have you checked the format of the file name you are trying to create? Do you get ':' in there anywhere?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

How are you archiving your output file?

If you are using the Backup card settings as in Backup->BackupLocation->Filename->Value, there is no way to introduce a timestamp.

Alternately, you can "archive" a file by using an additional output card and the PUT("File",...) function in the map rule which allows you to use FROMDATETIME (CURRENTDATE (),"{CCYYMMDDHH24MMSS0-9}") as part of your target filename.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: jvanboga

Or if the map creating the output is a 'runmap' you can override the output card path & filename with what you want.

When I've had similar problems it was due to punctuation issues related to time. If you aren't carefull with the format you could end up with a name like file_name.hh:mm:sss instead of file_name.hhmmss. The former won't create a file in windows.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Using a "runmap" to create output files is not generally recommended unless additional processing is required. This wouldn't be the case with creating an "archive" file. The PUT function is much faster and less resource intensive. For details, see the WTX Performance Recommendations Guide, Chapter 2, Routing, where test cases are shown to demonstrate the differences.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: jvanboga

I agree!

Using a runmap just to create an output file can exponentially increase the demand for system resources and should be avoided.

"if the map creating the output is a 'runmap'" the control map can override the output file name. When used appropriately there are benefits to either method over the other. Just need to determine what works best for each case.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange