Master File for Data Access With GETPRV

The Master File and attributes for data to be accessed using the GETPRV exit are the same as the attributes for any other FOCSAM data source, except that the SUFFIX value must be PRIVATE (no other value will invoke the exit), and a primary key must be specified as a GROUP with an ALIAS=KEY value. For example,

FILE=filename, SUFFIX=PRIVATE, $
 SEGNAME=ROOT, SEGTYPE=S0, $
  GROUP=keyname, ALIAS=KEY, USAGE=xx, ACTUAL=xx, $
   FIELD=fieldname1, ALIAS=aliasname1, USAGE=xx, ACTUAL=xx, $
   FIELD=fieldname2, ALIAS=aliasname2, USAGE=xx, ACTUAL=xx, $

Secondary keys are typically set up as follows:

FILE=filename, SUFFIX=PRIVATE, $
 SEGNAME=ROOT, SEGTYPE=S0, $
  GROUP=keyname, ALIAS=KEY, USAGExx, ACTUAL=xx, $
   FIELD=fieldname1, ALIAS=aliasname1, USAGE=xx, ACTUAL=xx, $
   FIELD=fieldname2, ALIAS=aliasname2, USAGE=xx, ACTUAL=xx, $
   FIELD=fieldname2, ALIAS=KEY1      , USAGE=xx, ACTUAL=xx, INDEX=I, $
   FIELD=fieldname2, ALIAS=KEY2      , USAGE=xx, ACTUAL=xx, INDEX=I, $

They may also be set up as follows:

FILE=filename, SUFFIX=PRIVATE, $
 SEGNAME=ROOT, SEGTYPE=S0, $
  GROUP=keyname , ALIAS=KEY , USAGE=xx, ACTUAL=xx, $
   FIELD=fieldname1,  ALIAS=aliasname1, USAGE=xx, ACTUAL=xx, $
   FIELD=fieldname2,  ALIAS=aliasname2, USAGE=xx, ACTUAL=xx, $
   GROUP=keyname    , ALIAS=KEY1      , USAGE=xx, ACTUAL=xx, INDEX=I, $
    FIELD=fieldname2, ALIAS=aliasname3, USAGE=xx, ACTUAL=xx, $
   GROUP=keyname    , ALIAS=KEY2      , USAGE=xx, ACTUAL=xx, INDEX=I, $
    FIELD=fieldname2, ALIAS=aliasname4, USAGE=xx, ACTUAL=xx, $

All standard rules for keys and discontiguous keys as described in the standard manuals for describing keyed sequential sources apply to the use of SUFFIX=PRIVATE and should also be consulted.

To reference a table, you must specify the physical name of the Master File (for example, mytable.mas) and it must be located in an application directory on the server application path. On MVS configurations using PDS for storing application files, the Master File must be in the PDS allocated to the DDNAME MASTER or be in a PDS for a given applications Master Files.


WebFOCUS