You can modify any of the attributes in the Metadata Field section of the screen. These attributes describe the fields of your TIBCO Object Service Broker DB2 table. Each time you press Enter the screen is validated.
Type over the name in the Name field with a new name to uniquely identify the field within the TIBCO Object Service Broker DB2 table. You can use the same name as a field in another table. If you are moving data between this table and another table, giving fields the same names simplifies the process; however, we recommend that you use the same field name as the DB2 column name.
Valid entries: a character string (unique to the TIBCO Object Service Broker DB2 table definition) of up to 16 characters beginning with a letter (A - Z) or a special character (@, $, or #), and continuing with more letters, special characters, digits (0 - 9), or underscore characters (_).
Change the TIBCO Object Service Broker semantic type (Typ field) and syntax (
Syn field) of the field. You can specify any valid semantic type and syntax combination that is supported for each DB2 data type. Valid combinations of type and syntax are described in
TIBCO Object Service Broker Programming in Rules, and the TIBCO Object Service Broker syntax supported for each DB2 data type is listed in the following table.
Changing the default field syntax of a DB2 column can cause conversion overhead since the Gateway must convert each affected field of each row to the new syntax as defined in the TIBCO Object Service Broker DB2 table definition.
Change the length in the Len field and, if applicable, the number of digits to the right of the decimal in the
Dec field. The data is padded or truncated as necessary.
Specify A (ascending) or D (descending) in the Ord field to determine the order of the occurrences.
If you are satisfied with your DB2 table definition, press PF3 to save the definition. If you do not want to save your changes, press PF12 to cancel them.
Press PF9 = RS_REFRESH to generate TIBCO Object Service Broker table definitions mapping the result sets, if any, produced by a stored procedure. The following screen is displayed:
If prompted for input values, specify them and press Enter. You will then be prompted to confirm the execution of the stored procedure for the specified set of input values. Upon confirmation (PF22), the procedure is executed and you will see displayed the values it has returned in its output and input/output parameters. In addition, a screen message will be displayed reporting the number of result sets built.
This process may be repeated any number of times. The table definer stores in a temporary repository the descriptions of the result sets built by this process. You may press PF12 = CANCEL to clean up this repository and return to the Table Define Screen, or PF3 = SAVE & EXIT to generate the persistent OSB table definitions mapping those result sets.
Under DB2 conventions, any result set returned by a stored procedure has a unique (within the scope of the stored procedure) name (up to 30 bytes long) assigned by the stored procedure. The TIBCO Object Service Broker table definer uses these names and the TIBCO Object Service Broker name of the procedure mapping being defined when generating result set mappings.
For example, if the TIBCO Object Service Broker table PROC maps the DB2 stored procedure EMPRSET that returns two result sets named CSR1 and CSR2, the names of TIBCO Object Service Broker tables generated by the definer will be PROCCSR1 and PROCCSR2.
In the Subtype field, specify the value P. Enter a schema and procedure name, or use the PF4 key to see a list of stored procedures.
The columns displayed are the parameters of the stored procedure. Two additional TIBCO Object Service Broker fields, @HANDLE@ and #RS#, are added to the definition. All fields are preselected; do not deselect any fields, as this will cause the call to the procedure to fail.
If the stored procedure has result sets available to the calling program, use the SP_INFO and SP_REFRESH PF keys to list and to automatically create table definitions for them.