Updating Text Descriptions using DBXLOAD

Document ID : KB000049664
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

If I wanted to update a description which is held in the extended text tables and also an attribute on the data table would it be possible to run one job to do the update?

Solution:

Yes, this can be accomplished using DBXLOAD.

To do so provide a DBXTEXT DD in the JCL pointing to a empty dataset.

In addition, use the EXTTEXT keyword in the DBXLOAD load syntax to specify which repository text table (1-5) should be updated.

Example.

//DBXTEXT DD DSN=TSREPO.DBXTEXT,DISP=SHR    <-------------------specify DBXTEXT DD and allocate a FB 80 dataset.  It can be empty                                                                    
//SQLTEMP   DD DSN=&LDTEMP,DISP=(NEW,DELETE,DELETE),UNIT=SYSDA,             
//             SPACE=(TRK,(50,20),RLSE),                                    
//             DCB=(LRECL=4044,BLKSIZE=16176,RECFM=FB)                      
//SYSUDUMP DD  SYSOUT=*                                                     
//SYSIN    DD  *                                                            
REUSE DATA FROM SYSRC00 ERROR SYSER00         <----------------REUSE keyword is required with the EXTTEXT keywords        
       VERSION 0 STATUS DBXT VALIDATE YES                                   
       SAVEAUDIT                                                            
       INTO DIALOG 'RECORDS' ENTITY 'REC EL'                                
  FIELDS (REC_EL_NAME      POS(0001) CHAR(22) READONLY,                    
             VERSION             POS(0024) INTEGER EXTERNAL(1) READONLY,        
             TITLE                 POS(0026) CHAR(17) ,                           
             EXTTEXT1           POS(0044) CHAR(114) )