My requirement is like this :Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIPif we run that job the target file names are like this sale_header_1_20060206 & sale_line_1_20060206.If we run next time means the target files we like this sale_header_2_20060206 & sale_line_2_20060206.If we run the same in next day means the target files we want like this sale_header_3_20060306 & sale_line_3_20060306.i.e., whenever we run the same job the target files automatically changes its filename to filename_increment to previous number(previousnumber + 1)_currentdate;Please do needful by repling this question..

  • Interview Candidate
  • 2
  • 1936

Showing Answers 1 - 2 of 2 Answers

Guest

  • Jul 13th, 2006
 

This can be done by using unix script

1. Keep  the Target filename as constant name xxx.psv

2. Once the job completed, invoke the Unix Script through After job routine - ExecSh

3. The script should get the number used in previous file and increment it by 1, After that move the file from xxx.psv to filename_(previousnumber + 1)_currentdate.psv and then delete the xxx.psv file.This is the Easiest way to implement.

Thanks,

Vimal T

  Was this answer useful?  Yes

sreedhark

  • Jul 14th, 2006
 

hi
thanks for response and sending that answer.
can u send me that unix script for getting and implementing sqeunce number in file names.
 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions