IBM Support

SYSTOOLS.GENERATE_SPREADSHEET

News


Abstract

The GENERATE_SPREADSHEET scalar function generates a file in the Integrated File System containing a spreadsheet based on either the results of a query or the complete content of a database file.

This scalar function relies upon the CLDownload feature provided by the IBM i Access Client Solutions (ACS) jar that ships on every IBM i. The ACS jar is delivered via the IBM HTTP SERVER FOR i PTF Group, and is found at this path: /QIBM/proddata/Access/ACS/Base/acsbundle.jar

Note: Launching IBM i Access Client Solutions will always start another service daemon job for the user that will show on IBM i as a QJVAEXEC job that will remain active. This is normal and can be referenced by subsequent launches of ACS by that user and should remain active.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > SYSTOOLS.GENERATE_SPREADSHEET
For complete detail, visit this IBM Documentation page: GENERATE_SPREADSHEET scalar function
 
Enhanced with IBM i 7.5 SF99950 Level 7 & IBM i 7.4 SF99704 Level 28:
  • A spreadsheet is generated with proportional width columns for xls and xlsx formats

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;and future releases"}]

Document Information

Modified date:
11 July 2024

UID

ibm17031280

Page Feedback