In this section: |
The DEDUCT table contains data on monthly pay deductions.
For DB2:
FILENAME=DEDUCT , SUFFIX=DB2,$ SEGNAME=DEDUCT ,SEGTYPE=S0,$ FIELDNAME=DEDEID ,ALIAS=EID ,USAGE=A9 ,ACTUAL = A9,$ FIELDNAME=DEDDATE ,ALIAS=PD ,USAGE=YMD ,ACTUAL = DATE,$ FIELDNAME=DED_CODE,ALIAS=DC ,USAGE=A4 ,ACTUAL = A4,$ FIELDNAME=DED_AMT ,ALIAS=DA ,USAGE=D12.2M ,ACTUAL = D8,$
Note:
For DB2:
SEGNAME = DEDUCT, TABLENAME = "USER1"."DEDUCT", KEYS = 3, WRITE = YES, KEYORDER = HIGH, DBSPACE = PUBLIC.SPACE0,$
For Teradata:
SEGNAME = DEDUCT, TABLENAME = USER1.DEDUCT, KEYS = 3, WRITE = YES, KEYORDER=HIGH, FALLBACK=YES,$
For IDMS SQL:
SEGNAME = DEDUCT, TABLENAME = DEDSCHEM.DEDUCT, KEYS = 3, WRITE = YES, KEYORDER = HIGH, DBSPACE = DEDSEG.DEDAREA,$
For Oracle:
SEGNAME=DEDUCT, TABLENAME=USER1.DEDUCT, KEYS=3, WRITE=YES, KEYORDER = HIGH, DBSPACE=SPACE1, $
check file deduct pict NUMBER OF ERRORS= 0 NUMBER OF SEGMENTS= 1 ( REAL= 1 VIRTUAL= 0 ) NUMBER OF FIELDS= 4 INDEXES= 0 FILES= 1 TOTAL LENGTH OF ALL FIELDS= 25 SECTION 01 STRUCTURE OF SQLDS FILE DEDUCT ON 06/16/93 AT 09.42.45 DEDUCT 01 S0 ************** *DEDEID ** *DEDDATE ** *DED_CODE ** *DED_AMT ** * ** *************** **************
Information Builders |