ADDRESS Sample

The ADDRESS table contains employees' home and bank addresses.

In this section: ADDRESS MASTER ADDRESS FOCSQL ADDRESS Diagram

ADDRESS MASTER

For DB2 or DB2 for VM:

FILENAME=ADDRESS  ,SUFFIX=SQLDS
 
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.

ADDRESS FOCSQL

For DB2 or DB2 for VM:

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, $

ADDRESS Diagram

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 **
 *            **
 ***************
  **************