Filter
Top Products
you press F3 (Exit) without making any changes to the display.
You are finished creating the definitions describing a database file. The instructions to create the file
and to enter data into the file are described in the following sections.
Query for iSeries query exercise: Creating a database file
After you have completed creating the necessary file definitions, you can create the database file using the
Work with Database Files display. You can get to this display either from the main IDDU menu or by
entering the Work With DB Files Using IDDU (WRKDBFIDD) command.
You can create as many files as you require by entering a new file name each time you return to the
display. These file names might have a level of authority previously assigned to them (authority holder).
This affects the authority that you can assign.
To create a database file, do the following:
1. Choose option 3 (Work with database files) from the IDDU menu (or type WRKDBFIDD on a command
line).
2. On the Work with Database Files display, choose option 1 (Create), name the new file, and specify the
library that will contain the file.
Work with Database Files
Library....... default___ Name,F4 for list
Position to..... __________ Starting characters
Type options (and Database file), press Enter.
1=Create 2=Enter data
Database Database Database Database
Opt File Opt File Opt File Opt File
3. Press the Enter key. The Create Database File display is shown with the names of the new file and its
library.
On this display, specify NAMEADDR for the file definition, SYSDIC for the dictionary (or the name of the
dictionary you created in the previous section of this appendix), and *CHANGE for the authority others
have to this file.
Create Database File
File...: NAMEADDR Library....: YOURLIB
Type choices, press Enter.
Related definition information:
File definition ...... NAMEADDR Name, F4 for list
Dictionary......... SYSDIC Name, F4 for list
Authority ......... *CHANGE *LIBCRTAUT, *ALL, *CHANGE
*USE, *EXCLUDE
Authorization list name
4. Press the Enter key to create the file. When the file is created, the system automatically links the file to
its file definition.
Press F3 (Exit) to return to the IDDU menu.
Query for iSeries query exercise: Entering data
To enter data into the file, do the following:
Appendix B. Practice exercise for Query for iSeries query 203