SALINFO Sample

The SALINFO table contains data on the employees' monthly pay.

In this section: SALINFO MASTER SALINFO FOCSQL SALINFO Diagram

SALINFO MASTER

For DB2 or DB2 for VM:

FILENAME=SALINFO,  SUFFIX=SQLDS,$
 
SEGNAME=SALINFO  ,SEGTYPE=S0,$
 FIELDNAME=SALEID   ,ALIAS=EID     ,USAGE=A9      ,ACTUAL=A9,$
 FIELDNAME=PAY_DATE ,ALIAS=PD      ,USAGE=YMD     ,ACTUAL=DATE,$
 FIELDNAME=GROSS     ,ALIAS=MO_PAY  ,USAGE=D12.2M  ,ACTUAL=D8,$

Note:

• For Teradata:
• Change the suffix value to SQLDBC.
• Change the USAGE format for GROSS 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.

SALINFO FOCSQL

For DB2 or DB2 for VM:

SEGNAME = SALINFO, TABLENAME = "USER1"."SALINFO", KEYS = 2,
 WRITE = YES,  KEYORDER = HIGH, DBSPACE = PUBLIC.SPACE0,$

For Teradata:

SEGNAME = SALINFO,TABLENAME = USER1.SALINFO, KEYS = 2, WRITE = YES,
    KEYORDER=HIGH, FALLBACK=YES,$

For IDMS SQL:

SEGNAME = SALINFO, TABLENAME = SALSCHEM.SALINFO, KEYS = 2,
 WRITE = YES,  KEYORDER = HIGH, DBSPACE = SALSEG.SALAREA,$

For Oracle:

SEGNAME=SALINFO, TABLENAME=USER1.SALINFO, KEYS=2, WRITE=YES,
    KEYORDER=HIGH, DBSPACE=SPACE1, $

SALINFO Diagram

check file salinfo pict
  NUMBER OF ERRORS=     0
  NUMBER OF SEGMENTS=   1  ( REAL=    1  VIRTUAL=   0 )
  NUMBER OF FIELDS=     3  INDEXES=   0  FILES=     1
  TOTAL LENGTH OF ALL FIELDS=   21
 SECTION 01
              STRUCTURE OF SQLDS    FILE SALINFO  ON 06/17/93 AT 13.52.04
 
          SALINFO
  01      S0
 **************
 *SALEID      **
 *PAY_DATE    **
 *GROSS       **
 *            **
 *            **
 ***************
  **************