Using SQL to create pdf || GENERATE_PDF
#ibmi #as400 #pdf #sql
Using SQL to create pdf,
using SQL to print pdf from spool file in IBM i,
The GENERATE_PDF scalar function generates a PDF file in the IFS from the spool files.
OUTPUT_QUEUE_ENTRIES
OUTPUT_QUEUE_ENTRIES_BASIC
WRKSPLF
SELECT * FROM QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC WHERE USER_NAME =
'EASYCLASS'
GENERATE_PDF() SQL UDF IN SYSTOOLS SCHEMA
SELECT PATH_NAME,OBJECT_TYPE
FROM TABLE(QSYS2.IFS_OBJECT_STATISTICS('/HOME/EASYCLASS'))