This Access File is used in the examples throughout this manual. For instructions about creating this Access File, see the sample session in Creating File Descriptions With AUTOIDMS:
$$$ CREATED BY AUTOIDMS ON 02/13/01 AT 14.32.16 BY PMSSAE
$$$ FILE=EMPFULL,SUFFIX=IDMSR,$
SSCHEMA=EMPSS01,RELEASE=12.0,MODE=DML,
DBNAME=EMPDEMO ,DICTNAME=APPLDICT ,$
SEGNAM=S0410_01,RECORD=DEPARTMENT,
AREA=ORG-DEMO-REGION,
CLCFLD=F0410_1,
CLCDUP=N,$
SEGNAM=S0415_02,RECORD=EMPLOYEE,
AREA=EMP-DEMO-REGION,
ACCESS=SET,SETNAME=DEPT-EMPLOYEE,
SETMBR=OA,GETOWN=Y,MULTMBR=N,
CLCFLD=F0415_1,
CLCDUP=N,
KEYFLD=F0415_4/F0415_3,
SETORD=A,SETDUP=Y,$
IXSET=EMP-NAME-NDX,IXDUP=Y,IXORD=A,
IXFLD=F0415_4/F0415_3,$
SEGNAM=S0400_03,RECORD=COVERAGE,
AREA=INS-DEMO-REGION,
ACCESS=SET,SETNAME=EMP-COVERAGE,
SETMBR=MA,GETOWN=Y,MULTMBR=N,$
SEGNAM=S0420_04,RECORD=EMPOSITION,
AREA=EMP-DEMO-REGION,
ACCESS=SET,SETNAME=EMP-EMPOSITION,
SETMBR=MA,GETOWN=Y,MULTMBR=N,$
SEGNAM=S0425_05,RECORD=EXPERTISE,
AREA=EMP-DEMO-REGION,
ACCESS=SET,SETNAME=EMP-EXPERTISE,
SETMBR=MA,GETOWN=Y,MULTMBR=N,
KEYFLD=F0425_1,
SETORD=D,SETDUP=Y,$
SEGNAM=S0460_06,RECORD=STRUCTURE,
AREA=EMP-DEMO-REGION,
ACCESS=SET,SETNAME=MANAGES,
SETMBR=MA,GETOWN=Y,MULTMBR=N,$
SEGNAM=S0450_07,RECORD=OFFICE,
AREA=ORG-DEMO-REGION,
ACCESS=SET,SETNAME=OFFICE-EMPLOYEE,
SETMBR=OA,GETOWN=Y,MULTMBR=N,
CLCFLD=F0450_1,
CLCDUP=N,
KEYFLD=F0415_4/F0415_3,
SETORD=A,SETDUP=Y,$
SEGNAM=S0405_08,RECORD=DENTAL-CLAIM,
AREA=INS-DEMO-REGION,
ACCESS=SET,SETNAME=COVERAGE-CLAIMS,
SETMBR=MA,GETOWN=N,MULTMBR=Y,$
SEGNAM=S0430_09,RECORD=HOSPITAL-CLAIM,
AREA=INS-DEMO-REGION,
ACCESS=SET,SETNAME=COVERAGE-CLAIMS,
SETMBR=MA,GETOWN=N,MULTMBR=Y,$
SEGNAM=S0445_10,RECORD=NON-HOSP-CLAIM,
AREA=INS-DEMO-REGION,
ACCESS=SET,SETNAME=COVERAGE-CLAIMS,
SETMBR=MA,GETOWN=N,MULTMBR=Y,$
SEGNAM=S0440_11,RECORD=JOB,
AREA=ORG-DEMO-REGION,
ACCESS=SET,SETNAME=JOB-EMPOSITION,
SETMBR=OM,GETOWN=Y,MULTMBR=N,
CLCFLD=F0440_1,
CLCDUP=N,$
IXSET=JOB-TITLE-NDX,IXDUP=N,IXORD=A,
IXFLD=F0440_2,$
SEGNAM=S0455_12,RECORD=SKILL,
AREA=ORG-DEMO-REGION,
ACCESS=SET,SETNAME=SKILL-EXPERTISE,
SETMBR=MA,GETOWN=Y,MULTMBR=N,
CLCFLD=F0455_1,
CLCDUP=N,
KEYFLD=F0425_1,
SETORD=D,SETDUP=Y,$
IXSET=SKILL-NAME-NDX,IXDUP=N,IXORD=A,
IXFLD=F0455_2,$
SEGNAM=S0415_13,RECORD=EMPLOYEE,
AREA=EMP-DEMO-REGION,
ACCESS=SET,SETNAME=REPORTS-TO,
SETMBR=OM,GETOWN=Y,MULTMBR=N,
CLCFLD=F0415_1A,
CLCDUP=N,$
IXSET=EMP-NAME-NDX,IXDUP=Y,IXORD=A,
IXFLD=F0415_4A/F0415_3A,$
Information Builders |