Release : 20.0
Component : CA Fast Unload for DB2 for z/OS
The correct syntax is:
Code the Select as:
SELECT 'MODIFY RECOVERY TABLESPACE ',
STRIP(DBNAME),'.',STRIP(NAME),'DELETE AGE (30)'
INTO
COL1 CHAR (27),
COL1 CHAR(8),
COL1 CHAR (1),
COL1 CHAR(12),
COL1 CHAR (15)
FROM SYSIBM.SYSTABLESPACE
WHERE DBNAME NOT IN ('DSNDB07','DSNDB04')
AND DBNAME NOT LIKE 'U%'