The New File functionality of the Adabas Manager allows the creation of simple Field Definition Tables (FDT). There is no limitation in the number of fields you can create or to their complexity; however, for the creation of extensive and complex FDTs, the use of the ADACMP utility is strongly recommended (for details see the section ADACMP: Compress-Decompress in the Adabas Utilities documentation).
Once you have started the creation of a new FDT, its status will be stored even after a cancellation or during inactivity of the user until a timeout occurs (for timeout settings, see Adabas Manager Session and Cache Administration). It is recommended though that you carry out the file creation process without interruption; once you click on the Adabas Manager entry in the tree-view or leave your session, any incomplete file creation process is terminated.
To create a new file for a database:
Select an Adabas database in tree-view and expand it.
Select Database Files in tree-view and right-click on it.
Select on the drop-down menu.
The New File panel appears in detail-view.
Note:
During the following file creation procedure, clicking
will return you to the previous page of the
New File (i.e., for modifications or additional entries);
will cancel the file creation and return to the
file list display (after cancellation, the system will store the settings you
have entered for the new file until you leave your session, a timeout occurs or
you click on the Adabas Manager entry in the
tree-view).
Enter the following parameter values for the new file:
File Number
File Name (optional)
MAXISN
Data Storage Size
Normal Index Size
Upper Index Size
Note:
If you click on the button next to the
File Number text box, the next free file number will be
displayed. If you enter a file number that already exists and click on the
button, the next free file number after the number
you entered will be displayed.
Click to continue with the file creation.
Page 2 of the New File appears in detail-view.
Define the File Descriptor Table for the new file. Complete the following entries:
Level
a one- or two-digit number in the range 01-07 (the leading zero is optional) used in conjunction with field grouping.
Name
the name to be assigned to the field (or group). Names must be unique within a file. The name must be two characters long: the first character must be alphabetic; the second character can be either alphabetic or numeric. No special characters are permitted.
Length
the length of the field (expressed in bytes).
Select the format in the selection box.
Check the options you want to set; enter the position of the field if required.
Click to add the field to the Field Definition Table of the new file.
Note:
Before the field is added to the FDT, Adabas
Manager performs a check on all entries. Field names and their
syntax and length are checked as well as any dependencies between fields and
between field attributes. Existing Special Descriptors are checked, so that for
example a field which is parent of a Special Descriptor cannot be deleted.
Group fields are initially defined with all properties. During generation of
the FDT, group fields are recognized and properties not required
(format/length) are not used.
In case of invalid values, the
resulting error messages will show you how to modify your entries so that the
field can be added to the FDT. For detailed information on the field
definitions see the section ADACMP: Compress-Decompress in
the Adabas Utilities documentation.
Specify all required fields and add them to the FDT.
Your entries are displayed in the table below the entry fields; to remove a field you created, click on its check box and then click .
To modify a field, select the field by clicking in the appropriate check box until a check mark appears and click .
After defining all fields, click to continue with the file creation.
Note:
Clicking if the definition of
special descriptors is not required will create the new file.
Page 3 of the New File appears in detail-view.
Define the Special Descriptor Table for the new file. Select the descriptor type in the selection box and complete the following entries:
Number
only available for hyperdescriptor and collation descriptor; the user exit number to be assigned to the descriptor. The Adabas nucleus uses this number to determine the descriptor user exit to be called.
Name
the name to be used for the descriptor/field. The naming conventions are identical to those for Adabas field names.
Length
only available for hyperdescriptors; the default length of the hyperdescriptor.
Select the format in the selection box.
Parent
the name of the field from which the super-/subfield or super-/subdescriptor is to be derived. For collation descriptors and hyperdescriptors, an elementary field.
The following table shows some examples of the parent field entry syntax required by Adabas Manager in comparison to the ADACMP syntax:
| Adabas Manager | ADACMP |
|---|---|
| AA,AB | HYPDE='01,HD,20,A,NU,MU=AA,AB' |
| AA(1,5) | SUBDE='SB=AA(1,5)' |
| AA | PHONDE='PH(AA)' |
| AA(1,5),BB(1,2),CC(3,5) | SUPDE='SP=AA(1,5),BB(1,2),CC(3,5)' |
| AA | COLDE='1,CD=AA' |
Check the options you want to set; enter the position of the field if required.
Click to add the descriptor to the Special Descriptor Table.
Note:
Before the field is added to the Special Descriptor Table,
Adabas Manager performs a check on all entries. In
case of invalid values, the resulting error messages will show you how to
modify your entries so that the field can be added to the FDT. For detailed
information on the field definitions see the section ADACMP:
Compress-Decompress in the Adabas Utilities
documentation.
Repeat the action for each descriptor you want to create.
The result of your modifications is shown in a table below the entry fields; to remove a descriptor you created, click on its check box and then click .
To modify a descriptor, select the field by clicking in the appropriate check box until a check mark appears and click .
After defining all required descriptors, click to continue with the file creation.
Note:
Clicking if the setting of optional
parameters is not required will create the new file.
The following optional parameters can be set:
| Property | Description | |||||
|---|---|---|---|---|---|---|
| ACRABN | The address converter RABN space. | |||||
| DSRABN | The data storage RABN space. | |||||
| NIRABN | The normal index RABN space. | |||||
| UIRABN | The upper index RABN space. | |||||
| ASSO Padding | The padding factor (percentage of each block) set for the ASSO dataset (the default is 10). | |||||
| DATA Padding | The padding factor (percentage of each block) set for the DATA dataset (the default is 10). | |||||
| Max. Blocks of DS Extents | The number of blocks allowed per secondary Data Storage extent ("0" indicates that the parameter is not set; the default then is no limit). | |||||
| Max. Blocks of NI Extents | The number of blocks allowed per secondary Associator normal index extent ("0" indicates that the parameter is not set; the default then is no limit). | |||||
| Max. Blocks of UI Extents | The number of blocks allowed per secondary Associator upper index extent ("0" indicates that the parameter is not set; the default then is no limit). | |||||
| Maximal Compressed Record Length | The maximum compressed record length (in bytes) allowed for the file (the default is the maximum possible size). You can also set | |||||
|
||||||
| Alpha Code | Current file encoding set for alphanumeric fields in the file. | |||||
| Wide Code | Current file encoding set for wide-character fields in the file. | |||||
| User Wide Code | Current user encoding set for wide-character fields in the file. | |||||
| MINISN | The lowest ISN that can be assigned to a record in the file ("0" indicates that the parameter is not set; the default then is "1"). MINISN is required for expanded files. | |||||
| ISN Size | Whether 3- or 4-byte ISNs are used for the file (the default is 3). You can also set | |||||
|
||||||
| Data Device | The device containing the Associator, Data Storage, or Work component. You can also set | |||||
|
||||||
| Anchor Fnr | Whether the file is part of an expanded file. You can also set | |||||
|
||||||
| Multi Client Owner-ID Length | The length of the internal owner ID for multiclient files (if Multi Client Support has been set). | |||||
| ADAMDE (Field/ISN) | Specifies the field to be used as the ADAM key (if the ADAM option has been selected for the file). | |||||
| ADAPARM | The number of bits to be truncated from the ADAM descriptor value before it is used as input to the ADAM randomizing algorithm (if the ADAM option has been selected for the file). A value in the range 1-255 may be specified. If this parameter is omitted, a value of 0 bits (no truncation) will be used. | |||||
| ADAM Overflow | The size of the Data Storage area to be used for ADAM file overflow (if the ADAM option has been selected for the file). |
Specify any parameters you may wish to set and click to create the new file.
