5.3.19 Operands related to work table files

59) pdwork -v "HiRDB-file-system-area-name"[,"HiRDB-file-system-area-name"]...
[Figure]<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 single server definition. If it is specified more than once, the first specification is effective.