HP 3000 Manuals HP 3000 Manuals
HP TurboIMAGE/iX Data Set Definition This lesson shows how to define the HP TurboIMAGE/iX data set for this part of the application. HP ALLBASE/4GL can store data for an application in HP TurboIMAGE/iX data sets. You have already defined the field specifications that will correspond to HP TurboIMAGE/iX data items. The record layout you defined is the HP ALLBASE/4GL equivalent of a data entry. As well as defining the HP TurboIMAGE/iX data set within HP ALLBASE/4GL, a physical data set in an HP TurboIMAGE/iX database must be created. Usually, the database would be created first, and the field specifications, record layouts and file definitions would be uploaded to HP ALLBASE/4GL using an HP ALLBASE/4GL utility. In this situation you would not need to redefine these items within HP ALLBASE/4GL. Refer to the HP TurboIMAGE/iX Interface section in the HP ALLBASE/4GL Developer Reference Manual for details of the upload utility.
NOTE If you intend to work through this section, make sure your HP ALLBASE/4GL administrator has already created an HP TurboIMAGE/iX database that corresponds with the field specifications, record layouts, and file definitions that you have created, and those that you will create in later lessons. If that has not been done, you can still read through this section, view the screens, and make the field entries. However, you will not be able to commit the screen.
The database created by your administrator should also contain the automatic master data sets that are normally linked to each key field in each data set. Task 1 - Defining an HP TurboIMAGE/iX Data Set As with the KSAM and SQL data sets, HP TurboIMAGE/iX data sets are defined on the file definition screen. Using the File Definition Screen On this screen you specify the name of the database that will contain the data set, the name by which the data set is known to the database system, and the record layouts to be used for the data set. You also enter a brief description that is used for documentation purposes. To access the screen from the main menu: 1. Select the Dictionary option. 2. Choose Database Items. 3. Choose Data File/SQL Table Definition.Data File/SQL Table Definition Screen The third window for this screen, selected by entering M in the File Type field, allows you to define HP TurboIMAGE/iX data sets. To enter the field values: Although you cannot commit the screen unless you have a TurboIMAGE database created, you can make the entries listed below to view the screen and window shown here. Field Entry Explanation --------------------------------------------------------------------------------------- File Name product Internal name of the file used by the application. Note that the name can be no longer than eight characters. File Type M Indicates the type of file and interface to be used. In this case it is a manual master data set in the HP TurboIMAGE/iX file interface. Description Enter a file description. HP ALLBASE/4GL displays the HP TurboIMAGE/iX file window automatically.HP TurboIMAGE/iX Window To enter values in the TurboIMAGE/iX window: Field Entry Explanation --------------------------------------------------------------------------------------- Database Name traindb Name of the HP TurboIMAGE/iX database that contains the data set you are defining. Can be up to eight characters long. This is not the external name of the HP TurboIMAGE/iX database, but rather, an internal name defined by the HP ALLBASE/4GL administrator in the administ application. Schema Data Set Name Accept the default. Name of the data set as it is known in the external HP TurboIMAGE/iX database schema file. The name may contain all characters that are acceptable in HP TurboIMAGE/iX data sets. All lowercase alphabetic characters are converted to uppercase characters. Default Record Accept the default. Indicates the record layout number to be used if no record name is specified in a file field reference. It is also used by the HP TurboIMAGE/iX data manager to create the file. You can't use a value other than 1 if you only have one record layout defined for the data set in the record layout list. Table 2-0. (cont.) Field Entry Explanation --------------------------------------------------------------------------------------- Record Layout List This is the header HP ALLBASE/4GL always builds the physical for the next 12 disk file records according to the default fields. You can record layout. enter the names of up to 12 different record layouts to be associated with this file. Record Layout List - product_rcrd Name of the record layout to be associated 1 with this file. Record Layout List - Leave these fields 2-12 blank. Notes on Windows. For information about the three File/SQL Table Creation windows and multiple record layouts, refer to the Field Notes section for KSAM files. To complete and commit the screen: 1. Press the Commit Data function key to create the file definition. If you do not have an HP TurboIMAGE/iX database defined, you will get an error message. When completed, this is the logical file definition for use in HP ALLBASE/4GL.
![[]](../../pic3k/M012318/FFN193c50.gif)
![[]](../../pic3k/M012318/FFN203c50.gif)