FUNDTRAN Sample

The FUNDTRAN table contains data about the employees' direct deposit accounts.

In this section: FUNDTRAN MASTER FUNDTRAN FOCSQL FUNDTRAN Diagram

FUNDTRAN MASTER

For DB2 or DB2 for VM:

FILENAME=FUNDTRAN ,SUFFIX=SQLDS
 
SEGNAME=FUNDTRAN, SEGTYPE=S0,$
 FIELDNAME=WHO          ,ALIAS=EID   ,USAGE=A9    ,ACTUAL=A9,$
 FIELDNAME=BANK_NAME    ,ALIAS=BN    ,USAGE=A20   ,ACTUAL=A20,$
 FIELDNAME=BANK_CODE    ,ALIAS=BC    ,USAGE=I6S   ,ACTUAL=I4,$
 FIELDNAME=BANK_ACCT    ,ALIAS=BA    ,USAGE=I9S   ,ACTUAL=I4,$
 FIELDNAME=EFFECT_DATE   ,ALIAS=EDATE ,USAGE=YMD   ,ACTUAL=DATE,$

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.

FUNDTRAN FOCSQL

For DB2 or DB2 for VM:

SEGNAME = FUNDTRAN, TABLENAME = "USER1"."FUNDTRAN", KEYS = 1,
    WRITE = YES, DBSPACE = PUBLIC.SPACE0,$

For Teradata:

SEGNAME=FUNDTRAN,TABLENAME=USER1.FUNDTRAN,KEYS=1,WRITE=YES,FALLBACK=YES,$

For IDMS SQL:

SEGNAME = FUNDTRAN, TABLENAME = FUNDSCHM.FUNDTRAN, KEYS = 1,
    WRITE = YES, DBSPACE = FUNDSEG.FUNDAREA,$

For Oracle:

SEGNAME=FUNDTRAN, TABLENAME=USER1.FUNDTRAN, KEYS=1, WRITE=YES,
    DBSPACE=SPACE1, $

FUNDTRAN Diagram

check file fundtran 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=   41
 SECTION 01
              STRUCTURE OF SQLDS    FILE FUNDTRAN ON 06/17/93 AT 13.53.15
 
          FUNDTRAN
  01      S0
 **************
 *WHO         **
 *BANK_NAME   **
 *BANK_CODE   **
 *BANK_ACCT   **
 *            **
 ***************
  **************