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) )