Updating Text Descriptions using DBXLOAD

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


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?


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.


//DBXTEXT DD DSN=TSREPO.DBXTEXT,DISP=SHR    <-------------------specify DBXTEXT DD and allocate a FB 80 dataset.  It can be empty                                                                    
//             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                                   
       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) )