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


Chapter 3 Tools : LOADER

LOADER
Loads definitions and data of TIBCO Object Service Broker objects that were previously unloaded, with selection control. (CE)
Invocation
Do one of the following:
From a rule, to use one action for all files
Type CALL LOAD_BY_ACTION(file[, defaultlib}, defn_action, data_action, media)
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)
Where:
 
[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.
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

 
File Loader Utility
File: ______________________________________________________________________
Send Report to: SCR SCR/PRT
Destination Library: ________ (Optional)
To LOAD on PF3 you must specify the two Actions
Action for definitions: __
Choose IS - Insert or Skip, IR - Insert or Replace
Action for data: __
Choose IS - Insert or Skip
IR - Insert or Replace
MI - Merge with Insert only
MR - Merge with Insert or Replace
 
 
 
PFKEYS: 5=SELECT 3=LOAD 2=LOGS 12=CANCEL

 
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.
Search Paths
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.
Other Notes
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.
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:
Cannot delete TDS_TABLE “%”, unable to verify promotion rights
Security Failure : Denied "OWNER" access to table “%”
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.
Unable to INSERT because of INTEGRITYFAIL: “%” is not a field of table “%”
This can be worked around by using the PF5 SELECT capability, selecting just the definition first, and then repeating the process for the data.
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 screen shows LOADER loading the items in the data set USR40.EXAMPLE.DATA(SCREENS) into the SCREENS library, with messages sent to the printer:

 
File Loader Utility
File: USR40.EXAMPLE.DATA(SCREENS)___________________________________________
Send Report to: PRT SCR/PRT
Destination Library: SCREENS_ (Optional)
To LOAD on PF3 you must specify the two Actions
Action for definitions: __
Choose IS - Insert or Skip, IR - Insert or Replace
Action for data: __
Choose IS - Insert or Skip
IR - Insert or Replace
MI - Merge with Insert only
MR - Merge with Insert or Replace
 
PFKEYS: 5=SELECT 3=LOAD 2=LOGS 12=CANCEL

 
With no actions specified, after pressing PF5, the following screen appears, where you specify an action for each definition in the file:

 
Select Objects to Load Scroll: P
File: USR40.EXAMPLE.DATA(SCREENS)
Command:
Name Object Exists Parameters/Library
---------------- ---------------- - ---------------------------------
__ SCR31 SCREEN N
__ SCRTAB31 SCR_TABLE N
 
Defn: IS Insert/skip IR Insert/replace
Data: IS Insert/skip IR Insert/replace MI Merge&insert MR Merge&replace
PFKEYS: 3=LOAD 12=CANCEL 5=REFIND 9=RECALL

 

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