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


Chapter 8 Managing VSAM Data Definitions : Task A: Identify the Table

Task A: Identify the Table
This step is used to:
Table Identification Segment
The following example illustrates the fields used to identify the table:

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

 
Table, Type, Unit, and IDgen Fields
The information for the Table, Type, Unit, and IDgen fields is entered by default. You can modify these fields, if necessary.
 
The table name displayed in the Table field is the one you specified when invoking the Table Definer. To save the definition of an existing table under a new name, type in the new name.
The type indicates how data is stored in the table or how data is to be accessed from a table. This field displays VSM, which you changed in Initial Step for Defining Tables.
The unit marks the table as belonging to a particular application or logical unit such as utilities, accounting, or network control.
The IDgen field determines whether a value should be generated for the primary key field. The default of N means that users who insert data into the table must enter a unique value for the primary key of each occurrence. A value of Y means that the system generates the value for the primary key of each occurrence. Type Y if you are defining a VSAM table for an external file that contains multiple record formats or multiple occurrences, or if you want a unique key for the VSAM table (so you can use the Table Browser).
If the table contains data and the IDgen field is set to Y, you can modify the field; however, if the field is set to N, you cannot modify the field.

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