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


Chapter 7 Mass Updates (z/OS) : Using the Mass Update Feature

Using the Mass Update Feature
What Conditions Apply?
The following conditions apply to making mass updates to data:
When the first non-duplicate insert succeeds, insert failures for duplicate key conditions are not recognized until a commit is issued or the end of the transaction is reached, and an unrecoverable error is signalled.
If the table is parameterized, during the mass update other transactions can update table instances that are not being updated. Other transactions cannot update an un-parameterized table during the mass update.
The IDgen attribute must be set to F. The IDgen attribute must be re-set to N or Y after the mass update to re-invoke the two-phase commit process.
Modifying the IDgen Attribute
The IDgen attribute, which is set as part of a table definition, is used to determine whether TIBCO Object Service Broker should generate values for the primary key field. This field accepts the following values:
The system generates a unique value for the primary key of each occurrence when data is inserted into a table.
Methods Available
The following methods are available to you to modify the IDgen attribute:
If the table definition has been bound, that is, FIX=Y, you cannot dynamically change the IDgen setting unless the table is unbound. Refer to Procedure to Bind or Unbind a Table for more information about binding.
Using the Table Definer
To use the Table Definer option, complete the following steps:
1.
A screen similar to the following appears.

 
COMMAND==> TABLE DEFINITION
Table: @EMPLOYEES Type: TDS Unit: DOCEXMPL IDgen: N
Source:
Parameter Name Typ Syn Len Dec Class ‘ Event Rule Typ Acc
---------------- - - --- -- - ‘ ---------------- - -
_ REGION I C 16 0 D ‘ _ DELETEMPNO T D
_ LOCATION I C 16 0 L ‘ _ VALIDEMPNO V I
Field Name Typ Syn Len Dec Key Ord Rqd Default Reference
---------------- - - ---- -- - - - ---------------- ----------------
_ EMPNO I P 3 0 P
_ LNAME S C 22 0 S
_ POSITION S C 14 0
_ MGR# I P 3 0 MANAGER
_ DEPTNO I B 2 0
_ SALARY Q P 4 2 0.00
_ ADDRESS S V 38 0
_ CITY S C 20 0
_ STATE_PROV S C 4 0
_ ZP_CODE S C 7 0
_ HIREDATE D B 4 0
_
PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRINT 14=FIELDS 21=DATA 2=DOC

 
2.
Using a Rule
You can use a rule similar to the following to change the IDgen attribute:

 
RULE EDITOR ===> SCROLL: P
SET_IDGEN(IDGEN_VALUE, TABLENAME);
_
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ GET TABLES WHERE NAME = TABLENAME; | 1
_ TABLES.IDGEN =IDGEN_VALUE; | 2
_ REPLACE TABLES; | 3
_ ---------------------------------------------------------------------------

 
Sample Rule to Do a Mass Update
The following rule uses:
1.
2.
The LOAD tool to load data into a table.
3.

 
RULE EDITOR ===> SCROLL: P
LOAD_TABLE(TABLENAME);
_
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ EXECUTE SET_IDGEN(’F’, TABLENAME); | 1
_ CALL LOAD(’USR40.TEST.UNLOAD(MANAGER)’, ’SCR’); | 2
_ EXECUTE SET_IDGEN(’N’, TABLENAME); | 3
_ ---------------------------------------------------------------------------

 

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