In this section: |
The FUNDTRAN table contains data about the employees' direct deposit accounts.
For DB2:
FILENAME=FUNDTRAN ,SUFFIX=DB2 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.
For DB2:
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, $
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 ** * ** *************** **************
Information Builders |