Set and Subset Physical Options Example

The following example illustrates the DASDL syntax for the set and subset physical options:

D DATA SET
 (
  A ALPHA(10);
  B BOOLEAN;
  F FIELD(8);
  N NUMBER(S5,2);
 )EXTENDED = TRUE;
S SET OF D
  KEY IS (N DESCENDING, A ASCENDING)
  SECTIONS (N = 20, A = "100";
            N = 20, A = "200";
            N = 10, A = "100";
            N = 10, A = "200";)
  LOADFACTOR = 75,
  BUFFERS = 2 + 2 PER USER,
  DISKPACK = SITEPACK,
  PRIME;