Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 9 Defining VSAM Tables for Files with Multiple Record Formats : Definition Requirements

Definition Requirements
Base and Child Definitions
You must define a base table and a separate table for each child record format. Define each of your required VSAM tables as described in Chapter 8, Managing VSAM Data Definitions.
Definition Requirements of a Child Table
You must also include the following for each of the child tables:
Do not provide data for this field; the system generates these values. As a result, each record in the TIBCO Object Service Broker VSAM table has a unique identifier provided by the IDgen field.
Define a data parameter that reflects the format of the associated base table key field. The base VSAM table definition does not require a parameter definition.
Data Parameter Requirements of a Child Table
The parameter name can be any valid TIBCO Object Service Broker field name, but TYPE, SYNTAX, LENGTH and DECIMALS must match the base VSAM table definition key fields.
Sample Definition (Record A)
The following is an example of a VSAM table definition for record A shown in the sample file on page , Sample File:

 
COMMAND==> TABLE DEFINITION

Table: EMPLOYEE_VSAM_A Type: VSM Unit: USR40 IDgen: N

File : USR40.EMPLOYEE.VSAM
DDname: Read Only: Y Load: N Data Set Type: KSDS
Ignore:
ServerID:

Parameter Name Typ Syn Len Dec Class ' Event Rule Typ Acc
---------------- - -- --- -- - ' ---------------- - -
_ ’ _
_ ’ _
------- VSAM --------|--------- ObjectStar Definition ------
Field Name Xsyn Xlen Xdec Offset Key Typ Syn Len Dec Ord Rqd Default
---------------- ---- ----- -- ----- - - -- ----- --- - - ----------
_ KEY B 2 0 0 P I B 2 0
_ DEPTNO B 4 0 2 I B 4 0
_ DEPTNAME C 9 0 6 S C 9 0
_
_
_
_
PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRT 14=FIELDS 6=OFFSET 21=DATA 2=DOC

 
Sample Definition (Record B)
The following is an example of a VSAM table definition for record B shown in the sample file on page <Link> “Sample File”. It includes a value for the REFERENCE field (scroll right to see this field):

 
COMMAND==> TABLE DEFINITION

Table: EMPLOYEE_VSAM_B Type: VSM Unit: USR40 IDgen: Y

File : USR40.EMPLOYEE.VSAM
DDname: Read Only: Y Load: N Data Set Type: KSDS
Ignore:
ServerID:

Parameter Name Reference Default ' Event Rule Typ Acc
---------------- ---------------- --------------- ' ---------------- - -
_ RECORD_A EMPLOYEE_VSAM_A ' _
_ ' _
------- VSAM --------|--------- ObjectStar Definition ------
Field Name Xsyn Xlen Xdec Offset Key Typ Syn Len Dec Ord Rqd Default
---------------- ---- ----- -- ----- - - -- ----- --- - - ----------
_ KEY B 4 0 P I B 4 0
_ LNAME C 22 0 S C 22 0
_ FNAME C 10 0 S C 10 0
_
_
_
_
PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRT 14=FIELDS 6=OFFSET 21=DATA 2=DOC

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved