HP Integrity NonStop J-Series User Manual

Page 70

Advertising
background image

DEVELOPING A DATA BASE
Creating a Data Base

-----------------------------------------------------------------
| |
| RESET |
| SET TYPE K |
| SET KEYLEN 26 |
| SET REC 26 |
| SET BLOCK 512 |
| SET IBLOCK 512 |
| CREATE DEPEND0 (17) |
| |
| |
| NOTES |
| |
| (1) Contains header information written by the DDL |
| compiler |
| |
| (2) Identifies an alternate key specifier ("en"), provides |
| the location of this key (KEYOFF 4) in bytes relative |
| to the start of a record, defines the key length |
| (KEYLEN 18) in bytes, and identifies the alternate key |
| file number (FILE 0). (FUP associates this alternate |
| key with the actual alternate key file by means of the |
| ALTFILE command described in note 3.) |
| |
| (3) Identifies the name of the alternate key file |
| ("employe0") associated with this data file |
| |
| (4) Indicates that the data file is a key-sequenced (K) |
| file |
| |
| (5) Identifies the location (KEYOFF 0) in bytes of the |
| primary key field |
| |
| (6) Identifies the length (KEYLEN 4) in bytes of the |
| primary key field |
| |
| (7) Identifies the length (REC 54) in bytes of the records |
| that can be stored by this data file |
| |
| (8) Identifies the data block length in bytes (BLOCK 512) |
| |
-----------------------------------------------------------------

Figure 3-10. Sample FUP Source Commands (Continued)

3-19

Advertising
This manual is related to the following products: