HP 3000 Manuals

HP ALLBASE/4GL Developer Reference Manual Vol. 1

File/SQL Table Creation Screen 

This screen allows you to create new HP ALLBASE/SQL tables or KSAM data
files from within HP ALLBASE/4GL.

You do not need to use this screen to create serial files.  If a serial
file does not already exist when the application first attempts to access
the file, HP ALLBASE/4GL automatically creates it.

HP TurboIMAGE/iX data sets are not physically created within HP
ALLBASE/4GL. Commonly, existing HP TurboIMAGE/iX databases will be
accessed, and the existing data set definition will be uploaded using HP
ALLBASE/4GL utilities.  Refer to chapter 10 for details about these
utilities.

Screen Image 


            

Field Description 

File Name   Enter the HP ALLBASE/4GL name of the HP SQL table or KSAM
file that you want to create.  You must complete the file/SQL table
definition screen for the table or file before you can use this screen to
create it.

The remainder of the fields on this screen are display only fields.  When
you enter the HP ALLBASE/4GL file name, the system displays the file
type, and its external name.  For HP ALLBASE/SQL tables, this screen also
displays the SQL access class and the SQL DBEFileset for the table.

For both HP ALLBASE/SQL tables and KSAM files this screen also shows the
details of the key fields defined for the record layout for the file, and
the description of the file.  For KSAM files, HP ALLBASE/4GL shows the
key fields defined for the default record layout.

Function Keys 

f1       File Defn  Cancels the current screen and displays the file/SQL
        table definition screen.

f3       Reformat File  Cancels the current screen and displays the data
        file reformat screen.

f4       Delete File  Cancels the current screen and displays the
        file/SQL table deletion screen.

Additional Information 

HP ALLBASE/4GL creates HP ALLBASE/SQL tables and KSAM data files
automatically when you press the  Commit Data  function key.

HP ALLBASE/SQL Table Creation.   

To use this screen to create an HP ALLBASE/SQL table, you must have
resource authority for the application DBEnvironment.  HP ALLBASE/4GL
transfers the ownership of the table to the SQL owner group specified for
the application on the application definition screen in the HP
ALLBASE/4GL administrator.  HP ALLBASE/4GL creates the table with all
columns allowing null values

If the table already exists and contains data, HP ALLBASE/4GL displays a
warning message.

KSAM Data File Creation.   

To create a KSAM data file, the MPE/iX group and account for the file
must exist, and you must have MPE/iX access permission for the group and
account.  Note that you cannot create a file in an account other than
your log-in account.

If the file already exists and contains data, HP ALLBASE/4GL displays a
warning message.

When you press the  Commit Data  function key to create a file, HP
ALLBASE/4GL calls an external file utility program to create the file.
The utility program uses a file-structure file, created by HP
ALLBASE/4GL, in the group and account specified by the variable
HP4FSPATH. The file-structure file is purged automatically when the KSAM
file has been created.

The file creation utility will fail if the file-structure file already
exists in the group and account specified by the variable HP4FSPATH.

HP ALLBASE/4GL creates three physical files whenever you create a KSAM
file.  For example, the HP ALLBASE/4GL file customer with an external
name of CUSTOMR would have the following disk files:

Filename                  Purpose 

CUSTOMR                   Data file

CUSTOMRK                  Key file

CUSTOMRS                  Structure file

All three files are created in the same group and account.

MPE/iX 5.0 Documentation