EMPINFO Sample

The EMPINFO table contains employee IDs, names, positions, and current salary information.

In this section: EMPINFO MASTER EMPINFO FOCSQL EMPINFO Diagram

EMPINFO MASTER

For DB2 or DB2 for VM:

FILENAME=EMPINFO      ,SUFFIX=SQLDS,$
 
SEGNAME=EMPINFO       ,SEGTYPE=S0,$
 FIELD=EMP_ID         ,ALIAS=EID         ,USAGE=A9    ,ACTUAL=A9,$
 FIELD=LAST_NAME      ,ALIAS=LN          ,USAGE=A15   ,ACTUAL=A15,$
 FIELD=FIRST_NAME     ,ALIAS=FN          ,USAGE=A10   ,ACTUAL=A10,$
 FIELD=HIRE_DATE      ,ALIAS=HDT         ,USAGE=YMD   ,ACTUAL=DATE,$
 FIELD=DEPARTMENT     ,ALIAS=DPT         ,USAGE=A10   ,ACTUAL=A10,
    MISSING=ON,$
 FIELD=CURRENT_SALARY ,ALIAS=CSAL        ,USAGE=P9.2  ,ACTUAL=P4,$
 FIELD=CURR_JOBCODE   ,ALIAS=CJC         ,USAGE=A3    ,ACTUAL=A3,$
 FIELD=ED_HRS         ,ALIAS=OJT         ,USAGE=F6.2  ,ACTUAL=F4,
    MISSING=ON,$
 FIELD=BONUS_PLAN     ,ALIAS=BONUS_PLAN  ,USAGE=I4    ,ACTUAL=I4,$
 FIELD=HIRE_DATE_TIME ,ALIAS=HDTT        ,USAGE=HYYMDm,ACTUAL=HYYMDm ,
    MISSING=ON,$
 FIELD=HIRE_TIME      ,ALIAS=HT          ,USAGE=HHIS  ,ACTUAL=HHIS  ,
    MISSING=ON,$

Note:

• For Teradata:
• Change the suffix value to SQLDBC.
• Change the ALIAS for LAST_NAME to LNAME.
• Change the ACTUAL format for CURRENT_SALARY to P8.
• Change the USAGE format for ED_HRS to D6.2 and the ACTUAL to D8.
• Remove the fields HIRE_DATE_TIME and HIRE_TIME.

• For CA-IDMS, change the suffix value to SQLIDMS. Also, remove the fields HIRE_DATE_TIME and HIRE_TIME.
• For Oracle, change the suffix value to SQLORA. Also, change the USAGE and ACTUAL formats for HIRE_DATE_TIME to HYYMDS and remove field HIRE_TIME.

EMPINFO FOCSQL

For DB2 or DB2 for VM:

SEGNAME = EMPINFO, TABLENAME = "USER1"."EMPINFO", KEYS = 1,
 WRITE = YES,  DBSPACE = PUBLIC.SPACE0,$

For Teradata:

SEGNAME = EMPINFO,TABLENAME = USER1.EMPINFO, KEYS = 1, WRITE = YES,
    FALLBACK=YES,$

For IDMS SQL:

SEGNAME = EMPINFO, TABLENAME = EMPSCHEM.EMPINFO, KEYS = 1,
 WRITE = YES, DBSPACE=EMPSEG.EMPAREA, $

For Oracle:

SEGNAME=EMPINFO, TABLENAME=USER1.EMPINFO, KEYS=1, WRITE=YES, DBSPACE=SPACE1, $

EMPINFO Diagram

check file empinfo pict
  NUMBER OF ERRORS=     0
  NUMBER OF SEGMENTS=   1  ( REAL=    1  VIRTUAL=   0 )
  NUMBER OF FIELDS=     9  INDEXES=   0  FILES=     1
  TOTAL LENGTH OF ALL FIELDS=   63
 SECTION 01
              STRUCTURE OF SQLDS    FILE EMPINFO  ON 06/16/93 AT 09.44.03
 
          EMPINFO
  01      S0
 **************
 *EMP_ID      **
 *LAST_NAME   **
 *FIRST_NAME  **
 *HIRE_DATE   **
 *            **
 ***************
  **************