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


Chapter 3 Tools : LOAD

LOAD
Loads definitions and data of TIBCO Object Service Broker objects that were previously unloaded. (CE)
Invocation
Do one of the following:
Type LOAD (importfile, media)<Enter>
Type EX LOAD (importfile, media) <Enter>
Type CALL LOAD(importfile, media).
Where:
 
Prerequisites
Items being loaded must have been unloaded using UNLOAD, UNLOAD_DATA, UNLOAD_DEFN or UNLOADLIBRARY. Refer to the appropriate entries in this manual for more information about these tools.
Usage Notes
Search Paths
If LOAD is executed using the EX option from the workbench, the search path used for event rules is local, SITE, and then COMMON.
If LOAD is executed using the LO or UL options from the @ADMIN menu, the search path is COMMON since the search path is indicated in MENU_ITEMS(@ADMIN) as S.
To LOAD a DB2 table definition that was unloaded from Release 5.0.0 into the current release, set library to S6B50DB2 and execute the LOAD tool. That task loads the definition and converts it to the format of the current release.
Loading Different Types of Objects
 
You are loading data from an operating system that is case-sensitive in its handling of filenames (such as Solaris) and you are loading a file with a name that is not entirely in upper case
Use the LLOAD shareable tool to load the file. In case-sensitive operating systems, if the file is in mixed or lower case, LOAD fails.
You want to load large volumes of data quickly
The value for importfile must be a fully qualified data set name.
Specify either the full path or only the filename. If you specify only the filename, the DSDIR Execution Environment parameter must be set to point to the directory to use. Refer to the TIBCO Object Service Broker Parameters manual for more information about this parameter.
The table must already exist. At minimum, it must contain the same fields (extra fields take on the default value). Changes in type, syntax and field order are allowed. If conversion errors result, that occurrence only is skipped.
LOAD and Existing Objects
Other Notes
If you execute LOAD without supplying values for importfile and media, pressing Enter displays a screen prompting for values.
When loading TDS data, if the definition of the table into which the data is being loaded is not bound, certain options are disabled. These options include reference checking, defaults, event rules, and the IDgen flag. These options are not disabled if the table definition is bound.
Definitions of all table types can be loaded using the LOAD tool. However, data for only TDS and session (SES) tables can be loaded using the LOAD tool.
When loading the definition and data of a table that has a secondary index, the secondary index is lost and the indicator is removed from the definition. You must run SIXBUILD to recreate the index.
To load on Windows or Solaris a file unloaded on z/OS, you must either issue FTP’s QUOTE SITE RDW command before sending the file from z/OS, or run the S6BBRFRU (Reformat TIBCO Object Service Broker Files Transferred with FTP) utility against the file on z/OS before using FTP.
See Also
TIBCO Object Service Broker for z/OS Utilities or TIBCO Object Service Broker for Open Systems Utilities for information on batch load utilities.
TIBCO Object Service Broker Parameters for information on the DSBIFTYPE Execution Environment parameter.
Example
The following statement loads the items in the data set USR40.EXAMPLE.DATA(RULES); any messages are sent to the screen:
EX LOAD('USR40.EXAMPLE.DATA(RULES)', 'SCR')
The following statement loads the items in the file /usr/usr40/RULES; any messages are sent to the printer:
EX LOAD('RULES', 'PRT')

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