In this section: |
The ADDRESS table contains employees’ home and bank addresses.
For DB2:
FILENAME=ADDRESS ,SUFFIX=DB2 SEGNAME=ADDRESS ,SEGTYPE=S0,$ FIELDNAME=ADDEID ,ALIAS=EID ,USAGE=A9 , ACTUAL = A9,$ FIELDNAME=TYPE ,ALIAS=AT ,USAGE=A4 , ACTUAL = A4,$ FIELDNAME=ADDRESS_LN1 ,ALIAS=LN1 ,USAGE=A20 , ACTUAL = A20,$ FIELDNAME=ADDRESS_LN2 ,ALIAS=LN2 ,USAGE=A20 , ACTUAL = A20,$ FIELDNAME=ADDRESS_LN3 ,ALIAS=LN3 ,USAGE=A20 , ACTUAL = A20,$ FIELDNAME=ACCTNUMBER ,ALIAS=ANO ,USAGE=I9L , ACTUAL = I4,$
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.
For DB2:
SEGNAME = ADDRESS, TABLENAME = "USER1"."ADDRESS", KEYS = 2, WRITE = YES, DBSPACE = PUBLIC.SPACE0,$
For Teradata:
SEGNAME = ADDRESS,TABLENAME = USER1.ADDRESS, KEYS = 2, WRITE = YES, FALLBACK=YES,$
For IDMS SQL:
SEGNAME = ADDRESS, TABLENAME = ADDSCHEM.ADDRESS, KEYS = 2, WRITE = YES, DBSPACE = ADDSEG.ADDAREA,$
For Oracle:
SEGNAME=ADDRESS, TABLENAME=USER1.ADDRESS, KEYS=2, WRITE=YES, DBSPACE=SPACE1, $
check file address pict NUMBER OF ERRORS= 0 NUMBER OF SEGMENTS= 1 ( REAL= 1 VIRTUAL= 0 ) NUMBER OF FIELDS= 6 INDEXES= 0 FILES= 1 TOTAL LENGTH OF ALL FIELDS= 77 SECTION 01 STRUCTURE OF SQLDS FILE ADDRESS ON 06/17/93 AT 13.51.17 ADDRESS 01 S0 ************** *ADDEID ** *TYPE ** *ADDRESS_LN1 ** *ADDRESS_LN2 ** * ** *************** **************
Information Builders |