Description:
In IDMSBCF/OCF you can include the 'DROP USER ' syntax as a literal field column in your select statement, to produce a report with the desired syntax.
Forexample: SELECT 'DROP USER ', AUTHID AS COLUMN1, ';' AS COLUMN2 FROM IDMSSECU.USER;
Solution:
This solution requires the SQL Option.
To produce 'DROP USER' syntax with a SELECT statement in OCF/BCF use the steps that follow:
*+ (CONST) COLUMN1 COLUMN2 *+ ------- ------- ------- *+ DROP USER USER1 ; *+ DROP USER USER2 ; *+ DROP USER USER3 ; *+ DROP USER USER4 ; *+ DROP USER USER5 ;
DROP USER USER1 ; DROP USER USER2 ; DROP USER USER3 ; DROP USER USER4 ; DROP USER USER5 ;