To create a user-defined file:

  1. To create a user-defined file, click the New button on the bottom of the User Files field. The following dialog box appears:

  2. Enter the logical file name in the Logical file name field (this is the path referenced by SQL commands and by DBMaker to reference the data).

  3. Enter a Physical File Name by entering a new path into the Physical file name field, or by clicking on The Browse Button ( ). This is the operating system path. . The maximum length for the Physical file name path is 256 characters.

  4. If you are running in a Unix environment set the file offset in the Raw Device Offset field.

  5. Enter a Page Size into the Page size box. This indicates the number of data pages allocated for the user-defined file. The range of values for a page size is between 2 and 524,287 bytes.

  6. Click OK. A new user-defined file will appear in the User Files field. The Logical File Name , Physical File name , and Page Size can be changed after the user-defined file has been created. Double-clicking on the text allows the user to edit it. This is useful if data files are moved within the operating system directory; DBMaker will not recognize a change in the Physical file name unless it is specified here.

    Figure: The User Files Field

  7. To delete a user-defined file click Remove. DBMaker will no longer recognize the logical file name.


Related topic:

Creating a User-Defined File