Using SQL to create pdf || GENERATE_PDF

Published: 01 January 1970
on channel: AS400 and SQL Tricks

169

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

On this page of the site you can watch the video online Using SQL to create pdf || GENERATE_PDF with a duration of hours minute second in good quality, which was uploaded by the user AS400 and SQL Tricks 01 January 1970, share the link with friends and acquaintances, this video has already been watched 169 times on youtube and it was liked by 3 viewers. Enjoy your viewing!