DEDUCT Sample

In this section:

The DEDUCT table contains data on monthly pay deductions.


Top of page

x
DEDUCT MASTER

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:


Top of page

x
DEDUCT FOCSQL

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, $

Top of page

x
DEDUCT Diagram
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