REF supplies the field attributes from a previously defined record format. You can specify the REF keyword only once. For a PF the record format name is specified along with an optional text description. Use the FORMAT keyword to specify that the operating system is to use a previously defined record format from another physical file.
When the FORMAT keyword is used, you must specify key-field level specifications again if a keyed access path is required even if they were specified on the existing record format. Record-level keyword used to specify that this record format is to share the field specifications for a previously defined record format.
The name of the record format you are defining must be the name of the previously defined record format. The database-file-name parameter is required. It is the name of the physical or logical file from which the previously defined record format is taken. The library-name is optional. They can be the same as or different from the previously defined record format.
If the database file from which you are using the record format is deleted, the record format remains in existence as long as some file is using the record format. Both files have been created.
The record-level keyword is used to supply a text description of the record format and it is used for documentation purposes only. The text must be enclosed in single quotation marks. If the length of the text is greater than 50 positions, only the first 50 characters are used by the high-level language compiler. The field names and field lengths are specified along with an optional text description for each field. When the program is compiled, the alternative name is brought into the program instead of the DDS field name.
The CCSID keyword is a file- or field-level keyword on physical files, and a field-level keyword on logical files. Files Libraries and Folders. Share this: Print. Like this: Like Loading Written by ASi Profile. Reply 2. Follow us on. Up Next: Library List. Young people knows how to run fast but old people knows the way.. Comment Post Cancel. November 12, , AM. Re: Flat File. Originally posted by pramendra View Post. Actually flat files are nothing but a physical file with only one column.
Re: Flat File A flat file is just a plain text file, usually with one line per record. If you were to write out a CSV file in notepad then that would be a flat file. If you wanted to you could also write that same data into a source member of type TXT. You could even create a physical file and add your CSV data to it. The trouble with these last two is that they are only any good on an AS and they're not true flat files. My friend showed me your blog and I have been reading it ever since.
Post a Comment. Friday, July 4, Flat File. Flat File: Flat files are physical files that have no field definitions and no indexes built off of them. Flat files, Record format and Field are all same. They all have a same name. We can write, read, update, delete the Flat file. Reading and Deleting can be done normally where as update and writing requires the use of Data Structures.
Let me discuss one by one.
0コメント