![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Loads definitions and data of TIBCO Object Service Broker objects that were previously unloaded, with selection control. (CE)
Developer’s workbench From a rule, to use one action for all files From a rule, to use different actions for different files Type CALL FILL_LOADPROMPT(file[, defaultlib]), and then type CALL LOADER_TABLE(file[, defaultlib], media)
[Optional] The name of the library where you want the information loaded. If entered, this argument must be the name of an existing library. IS – Insert or Skip. When an object in the file has the same name as one already in the database, this action skips the object in the file, and the database is to remain unchanged.IR – Insert or Replace. When an object in the file collides with one already in the database, the object in the file replaces the one in the database. IS – Insert or Skip. If there is already data in the table, or in one instance of a parameterized table, for example, this actions skips the data in the file.IR – Insert or Replace. If there is already data in the table, or in one instance of a parameterized table, for example, this action clears the table and loads the data in the file.MI – Merge with Insert only. When there is data in the file and data in the table, this action tests every occurrence from the file against the table. If the occurrences collide, in the sense of having identical primary keys, the occurrence from the file is skipped; otherwise, it is inserted.MR – Merge with Replace. This action tests individual occurrences from the file against the table. If the occurrences have identical primary keys, the one from the file replaces the one in the table; otherwise the one from the file is inserted.
• 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.
• To load the data into a table that uses required, reference, or default fields, you must have MODIFY_DEFN rights to that table.
From this screen, you can load information by filling in the different fields according the specifications under Invocation.
• To use PF3, you must specify the actions to be used with all files in the Action for definitions field and in the Action for data field.
• When you press PF5, you can specify, on the screen that follows, the actions to be taken for each individual objects. If the action is left blank for a definition, that item is not loaded.If LOADER is executed using the EX option from the workbench, the search path used for event rules is the local, the installation (the default is SITE), and the system (the default is COMMON) libraries.
• 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 LOADER tool. However, only TDS and session (SES) table data can be loaded using the LOADER 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.
• On non-z/OS systems, set the DSBIFTYPE Execution Environment parameter to LENGTH_PREFIXED_EBCDIC.
• Do not load DB2 table definitions unloaded from Release 5.0.0 into a system at the current release with LOADER. Use the LOAD shareable tool instead.
• Problems may be experienced if Borrower Rights are held on an existing object being replaced, even if the Borrower is the user invoking LOADER:
• Replace of a definition will fail if the user running LOADER is not either the Owner of the existing object or a level-7 user:
• Using LOADER to replace (IR) an existing table definition with a modified one containing, for example, a new field - and then attempting to load data to that modified table at the same time will fail as the 'old' definition is still being reference at the time the data is loaded.This can be worked around by using the PF5 SELECT capability, selecting just the definition first, and then repeating the process for the data.TIBCO Object Service Broker for z/OS Utilities or TIBCO Object Service Broker for Open Systems Utilities for information on batch load utilitiesTIBCO Object Service Broker Parameters for information on the DSBIFTYPE Execution Environment parameterThe following screen shows LOADER loading the items in the data set USR40.EXAMPLE.DATA(SCREENS) into the SCREENS library, with messages sent to the printer:
With no actions specified, after pressing PF5, the following screen appears, where you specify an action for each definition in the file:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |