COURSE Sample

The COURSE table lists the courses that the employees attended.

In this section: COURSE MASTER COURSE FOCSQL COURSE Diagram

COURSE MASTER

For DB2 or DB2 for VM:

FILENAME=COURSE ,SUFFIX=SQLDS,$
 
SEGNAME=COURSE  ,SEGTYPE=S0  ,$
 FIELD=CNAME   ,ALIAS=COURSE_NAME ,USAGE=A15, ACTUAL=A15,$
 FIELD=WHO     ,ALIAS=EMP_NO      ,USAGE=A9,  ACTUAL=A9,$
 FIELD=GRADE   ,ALIAS=GRADE       ,USAGE=A1,  ACTUAL=A1, MISSING=ON,$
 FIELD=YR_TAKEN,ALIAS=YR_TAKEN    ,USAGE=A2,  ACTUAL=A2,$
 FIELD=QTR     ,ALIAS=QUARTER      ,USAGE=A1,  ACTUAL=A1,$

Note: For Teradata, change the suffix value to SQLDBC, for CA-IDMS, change the suffix value to SQLIDMS, and for Oracle, change the suffix value to SQLORA.

COURSE FOCSQL

For DB2 or DB2 for VM:

SEGNAME = COURSE, TABLENAME = "USER1"."COURSE", KEYS = 2, WRITE = YES,
    DBSPACE = PUBLIC.SPACE0, $

For Teradata:

SEGNAME=COURSE, TABLENAME=USER1.COURSE, KEYS=2, WRITE=YES, FALLBACK=YES,
$

For IDMS SQL:

SEGNAME = COURSE, TABLENAME = CRSSCHEM.COURSE, KEYS = 2, WRITE = YES,
    DBSPACE = CRSSEG.CRSAREA, $

For Oracle:

SEGNAME=COURSE, TABLENAME=USER1.COURSE, KEYS=2, WRITE=YES,
  DBSPACE=SPACE1, $

COURSE Diagram

check file course pict
  NUMBER OF ERRORS=     0
  NUMBER OF SEGMENTS=   1  ( REAL=    1  VIRTUAL=   0 )
  NUMBER OF FIELDS=     5  INDEXES=   0  FILES=     1
  TOTAL LENGTH OF ALL FIELDS=   28
 SECTION 01
              STRUCTURE OF SQLDS    FILE COURSE   ON 06/17/93 AT 13.51.41
 
          COURSE
  01      S0
 **************
 *CNAME       **
 *WHO         **
 *GRADE       **
 *YR_TAKEN    **
 *            **
 ***************
  **************