1 / 12

Once a physical file has been created, how can data be loaded into it?

Once a physical file has been created, how can data be loaded into it?. DFU SQL Copy File Write a program. List all of the steps required to create a program described file and to put data into it. Use the CRTPF command to create the file with a specific record length

lukehicks
Download Presentation

Once a physical file has been created, how can data be loaded into it?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Once a physical file has been created, how can data be loaded into it? • DFU • SQL • Copy File • Write a program

  2. List all of the steps required to create a program described file and to put data into it. • Use the CRTPF command to create the file with a specific record length • Use a ‘Copy’ command to copy data into the file, or SQL, or write a program, or DFU.

  3. Working with Query/400

  4. Query/400 • Report Generator Tool • Creates objects with the type *QRYDFN

  5. Query/400 does the following: • Selection and arrangement of records in a file • Selection and placement of fields • Specification of report breaks • Ability to examine a report layout and preview a report • Ability to print a report based on the contents of one or more files without programming. • Ability to create a file based on the contents of one or more files without programming.

  6. To access Query/400 use the commands: STRQRY or WRKQRY

  7. Creating A Query • Select option 1 from Work with Queries • Enter query name and library where it is to be stored • Press enter!

  8. Defining the Query • You are presented with a list of selections. Place a 1 in the opt field beside those you want to use. The only one you must choose is File Selection. • Choose other selections as needed for sorting, editing fields, selecting of records, defining new fields, selecting output type, etc.

  9. Query Demo • Single File • Multiple Files

  10. Helpful Tips • Remember to hit ENTER after making your selections • Use the ampersand (&) to indicate a space in edit words • You can use field names in text areas by specifying the field name with an & in front of it. Eg. &DEPT Totals would yield text of Accounting Totals if DEPT was Accounting

  11. Creating a Permanent DFU • STRDFU, option 2 to create a DFU • name the DFU and choose the file • define general information screen: accept defaults • define Audit control: accept defaults • work with record formats: select format • select and sequence fields • work w/fields: select #2 to change headings, do editing, validation, etc

  12. DFU demo

More Related