HP Integrity NonStop J-Series User Manual
Page 70
![background image](/manuals/396723/70/background.png)
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