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 12/13/12 AT 14.32.16 BY USERID $$$ 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 |