seperate a file to different file

Original Message

Name: leng
Date: October 25, 2007 at 23:56:32 Pacific
Subject: seperate a file to different file
OS: alpha vms
CPU/Ram: 4
Model/Manufacturer: hp

Comment:

i am need in vms, i wrote a procobol file which is used to extract data from datawarehouse, the output file will be in DAT format. i need to write a COM file which is use to seperate all the data frm the DAT file based on the scenario and mail to respective person.
logic will be:
1. after generated the DAT file,Search scenario by scenario and output to different files
2.search "scenario1","scenario2","scenario3". ..in DAT file and output to scenario1.dat,scenario2.dat, scenario3.dat...
3. verify whether the scenario1.dat,scenario2.dat, scenario3.dat... had any content by size
4.if had contents, then mail to respective person.
5. loop back again for next scenario until end of the scenario.

Report Offensive Message For Removal

Response Number 1

Name: HakZan
Date: October 27, 2007 at 02:23:10 Pacific
Subject: seperate a file to different file

Reply: (edit)

$ search file.DAT "scenario1" /output=scenario1.lis
$ search file.DAT "scenario2" /output =scenario2.lis
$ search file.DAT "scenario3" /output=scenario3.lis
$ if f$file_attribute("scenario1.lis","ALQ") .gt. 0 then mail/subject="scenario1" scenario1.lis 'mailadress'
and so on.......

Report Offensive Follow Up For Removal


how to check if a file exists using to write system errors into a file append a file changing chars in a file from DCL OpenVMS VAX boot question	How to Search a Keyword in a File strings into a file String too long to write into file Content file to symbol convert vms files to windows