![]() ![]() Set v_failure_text = 'Generate_PDF: FAILED WITH SQLCODE= ' concat Get diagnostics condition 1 local_sqlcode = db2_returned_sqlcode, Set v_failure_text = 'Generate_PDF: Missing prerequisite software: 5770TS1 - Option 1 - Transform Services - AFP to PDF Transform ' ĭeclare v_cmdtxt varchar( 10000) for sbcs data Where product_id = '5770TS1 ' and product_option = '1 ' and installed = 'YES ' and load_error = 'NO ' Select count( *) into Transform_Services_exists Count must be 1 to be able to generate pdfs into the IFS lprintf( 'Generate_PDF: Cannot check whether this software is installed: 5770TS1 - Option 1 - Transform Services - AFP to PDF Transform ') If (software_product_info_exists = 0) thenĬall systools. Where service_name = 'SOFTWARE_PRODUCT_INFO ' Select count( *) into software_product_info_exists ![]() Count must be 1 to be able to check on software pre-req This scalar function allows the SQL programmer to identify Spooled File(s) and generate pdfs for them in the IFS.ĬREATE or replace FUNCTION SYSTOOLS.Generate_PDF(ĭeclare local_sqlstate char( 5) for sbcs data ĭeclare v_message_text varchar( 2000) for sbcs data ĭeclare v_failure_text varchar( 2000) for sbcs data ĭeclare software_product_info_exists integer ĭeclare Transform_Services_exists integer title: Generate PDF(s) from Spooled Files
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |