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


Appendix A Defining Batch Load Control Cards Manually : Input Definition Cards

Input Definition Cards
The input definition card describes the layout of the user input record. Each field on the input record must be defined, whether or not it is to be loaded into the TIBCO Object Service Broker table.
Field Values
CARD TYPE (column 1)
The card type for the input definition card is I.
SEQUENCE # (columns 3 – 5)
The cards for the input definition must arrive in the order the fields appear on the input record. The sequence numbers are defined to ensure this sequence is maintained.
ENTRY TYPE (column 7)
There are two possible values for the entry type of input cards:
The card specifies the file as variable or fixed length. An indicator of V or F is set in the type field (column 46). Entry type R cards must come before entry type F cards.
If the record type card is omitted, the input file is assumed to be fixed length.
NAME (columns 9 – 44) (Input Definition ENTRY TYPE F only)
The name field is defined to provide a cross reference between user input and TIBCO Object Service Broker output field names. The field is 36 bytes long.
TYPE (column 46) (Input Definition ENTRY TYPE R only)
The file type. Must be V (variable-length) or F (fixed-length).
SYNTAX (columns 45 – 48) (Input Definition ENTRY TYPE F only)
The syntax field is used to indicate the syntax of the input field. The syntax is left-justified if it is a raw-data or Unicode syntax; otherwise, it is right-justified.
If this syntax is either B (binary) or P (packed), in the cross-referenced target field, Output Definition Entry Type F entry, you must enter the null equivalent value. If left blank, the default null equivalent value takes effect. For more information, refer to Appendix C, Null Handling.
If you want to load data directly into a field with a semantic type of date, you must define your input data field with a syntax of C (alphanumeric) and the data must be in your site default format (for example, 1998-03-01). If your input data is not in this format or does not have syntax C, you can use an exit as described in S6BBRTBL (Batch Load) to convert the data before loading it into the table.
Field Length (columns 49 – 52) (Input Definition ENTRY TYPE F only)
This field specifies the length of an input field. Refer to TIBCO Object Service Broker Managing Data for information on permitted lengths.
Decimal Position (columns 54 – 55) (Input Definition ENTRY TYPE F only)
This field defines the number of post decimal positions for a numeric field. If omitted, the decimal position defaults to 0.
Offset (columns 59 – 62) (Input Definition ENTRY TYPE F only)
The offset defines the location of the field within the input record. The field is optional. If omitted, the offset is calculated.
Table Name (columns 64 – 79) (Input Definition ENTRY TYPE F only)
The specification of Table Name is required to allow the program to match input and output fields. This field should contain the field name in the TIBCO Object Service Broker TDS table definition that cross-references the input field name. If omitted, the input field is ignored.

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