wc -l filename.txtor
cat -n filename.txt
QSH CMD('/QOpenSys/pkgs/bin/find /directory_where_files_are/ -mtime +10 -type f -name ''*.pdf'' -delete') Example:
SELECT MESSAGE_ID FROM QUSRBRM.BRMS_LOG_OMITS
Parameters :
QUSRBRM.MEDIA_LIBRARY_MEDIA_INFO (MEDIA_LIBRARY => media-library, VOLUME_ID => volume-id, CATEGORY => category, BRM_VOLUME => brm-volume, MEDIA_CLASS => media-class, BRMS_STATUS => brms-status)
category : *ALL / *EJECT / *INSERT / *IPL / *NL (non labeled)/*NOSHARE / *SHARE400
brm-volume : *ANY / *NO (non-BRMS) / *YES (BRMS)
media-class : *ALL / media-class-name
brms-status : *ALL / *ACT / *ERR / *EXP / *INZ
Error messages returned by this procedure :
SELECT * FROM TABLE(QUSRBRM.MEDIA_SET_INFO('000013'))
MEDIA_LIBRARY_INFO view returns information that can also be seen through the Work with Media Library Status (WRKMLBSTS) command interface
also QUSRBRM / CG_BACKUP_STATUS
source for this view is