In this section: |
The SALINFO table contains data on the employees’ monthly pay.
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 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, $
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 |