Hi All,
Here i need to create Control File Definition in my Current Package, Please guide me how to develop this Program.My Requirement as below.
Control File Definitions
The control file will be named similarly to the data file with an extension ".CTL"
The control file will contain ONE only record.
The control record will hold details about the delivered data file.
The control record will hold total 26 byte record length.
The format of the control record will be as follows:
Fieldname
Data Type and format
Definition
FileDate CHARacter 8 format 'YYYYMMDD' The date the file was created.
DataDate CHARacter 8 format 'YYYYMMDD' The date the data is for. Allows for data to be created post the date of the records.
NbrRecords CHARacter/Numeric Format 9(10)
No leading zeroes, numeric only, no decimal place, no commas etc. The NUMBER of records in the data file
Thanks