DEDUCT Sample

The DEDUCT table contains data on monthly pay deductions.

In this section: DEDUCT MASTER DEDUCT FOCSQL DEDUCT Diagram

DEDUCT MASTER

For DB2 or DB2 for VM:

FILENAME=DEDUCT ,  SUFFIX=SQLDS,$
 
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 Teradata, change the suffix value to SQLDBC, the USAGE format for DED_AMT to P9.2, and the ACTUAL to P8.
• For CA-IDMS, change the suffix value to SQLIDMS.
• For Oracle, change the suffix value to SQLORA.

DEDUCT FOCSQL

For DB2 or DB2 for VM:

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

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     **
 *            **
 ***************
  **************