Free software training Videos

Free software training Videos
https://www.youtube.com/user/VLRTraining

List Of Best WebSites

Showing posts with label field reference file physical file. Show all posts
Showing posts with label field reference file physical file. Show all posts

Monday, 31 December 2012

field reference file in as400

A field reference file is a physical file which is used for defining most of your commonly used fields. Then when you need to create / modify a physical file you can use the definitions from the field reference file by using the REF(reference file) and REFFLD (reference field) keywords.
http://itknowledgeexchange.techtarget.com/itanswers/what-is-field-reference-file/
Field Reference Files:
• A physical file that contains no data, but only description of fields.
• It is used as a reference for the field descriptions of other files
Importance of using Field Reference Files
It enforces the naming convention
• Reduces programmer’s work load (define once, use often)
• It defines in one place all data elements used in the application for all users
Naming Conventions
• The file name, record format name, field name cannot be more than 10 character’s
• The first character should be alphabetic
• Field names should be unique in a record format
• Record format names and member names should be unique in a file
• File names should be unique in a library
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fdbp%2Frbafocrref.htm