SALINFO Sample

In this section:

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

SALINFO MASTER

For DB2:

FILENAME=SALINFO,  SUFFIX=DB2,$
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.

Top of page

SALINFO FOCSQL

For DB2:

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

Top of page

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

Information Builders