COURSE Sample

In this section:

The COURSE table lists the courses that the employees attended.
Top of page
x
COURSE MASTER

For DB2 : 

FILENAME=COURSE ,SUFFIX=DB2,$
SEGNAME=COURSE  ,SEGTYPE=S0  ,$
 FIELD=CNAME   ,ALIAS=COURSE_NAME ,USAGE=A30, ACTUAL=A30,$
 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.
Top of page
x
COURSE FOCSQL

For DB2: 

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, $
Top of page
x
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    **
 *            **
 ***************
  **************
Information Builders