8.3.18 Operands related to the work table files
- 53) pdwork -v "HiRDB-file-system-area-name"[,"HiRDB-file-system-area-name"]...
<pathname of up to 141 characters>- This operand must be specified in order to execute SQL statements.
- Specifies the names of HiRDB file system areas for work table files. Work table files are used for temporary storage of information during execution of SQL statements; they are created automatically by HiRDB. For details about the SQL statements that require a work table file, see the HiRDB Version 8 Description.
- Notes
- Specify in this operand the HiRDB file system area that was initialized using the pdfmkfs command.
- If the size of the work table file is large, specify a large HiRDB file system area. For the method of estimating the work table file size, see the HiRDB Version 8 Installation and Design Guide.
- The HiRDB file system areas for work table files must be different from the HiRDB file system areas for system files and RDAREAs.
- You cannot specify a HiRDB file system area created on a raw I/O.
- Operand rules
- At least one HiRDB file system area must be specified.
- A maximum of 16 HiRDB file system areas may be specified.
- This operand may be specified only once in the back-end server definition. If it is specified more than once, the first specification is effective.
- The specified HiRDB file system areas must not be used for other back-end servers.