IBM Support

HOW TO USE PLUGIN/cldownload with Colheadings and usecollabels ACS

How To


Summary

Example of result that uses "PLUGIN/cldownload" with Colheadings and usecollabels ACS.

Objective

Environment

Access Client Solution (ACS) Version 1.1.8.8
Duplicate and changed file CUSTALL from QIWS/QCUSTCDT 
Link of SAVF CUSTALL available.
IBM I Version, which is not End Of Support

Steps

First, create a new object with this command:
EG: CPYF FROMFILE(QIWS/QCUSTCDT) TOFILE(MYLIB/CUSTALL) MBROPT(*ADD) CRTFILE(*YES)   
The file CUSTALL changed by using Heritage IBM Navigator for i.                                                                     
Now the new object is a personal object (it is not beginning with a Q).
You can check it with the following commands
Strsql
Enter
Select * from MYLIB.CUSTALL
Enter
Or
using ACS => Run SQL Script
image-20220720142624-1
In the previous view, select Tools, then Shemas == > another time Shemas > the LIB > all Database Objects and double-click the CUSTALL file.
image-20220720144401-2
So with /colheadings=0 no header shown (by using latest ACS Version)

/colheadings=<1/0> - Include column headings as the first row. When specified, the column names are the heading.

/colheadings=1 show ALIAS in DDS

/colheadings=1 /usecollabels show COLHDG in DDS

 /usecollabels - Use column labels for the heading       

Example of commands given:  

  Set the path where is the file acsbundle.jar depending on the installation path selected.      

  C:\*\IBM\ClientSolutions\acsbundle.jar

  java -Xmx1024m  -Dcom.ibm.iaccess.dataxfer.SheetId=%1$s -jar acsbundle.jar /PLUGIN=cldownload /system=MySYSTEM /hostfile=MYLIB/CUSTALL /clientfile=/Temp/test.xlsx  /colheadings=0

image-20220715123416-2

java -Xmx1024m  -Dcom.ibm.iaccess.dataxfer.SheetId=%1$s -jar acsbundle.jar /PLUGIN=cldownload /system=MySYSTEM /hostfile=MYLIB/CUSTALL /clientfile=/Temp/test.xlsx   /usecollabels
image-20220715123148-1

java -Xmx1024m  -Dcom.ibm.iaccess.dataxfer.SheetId=%1$s -jar acsbundle.jar /PLUGIN=cldownload /system=MySYSTEM /hostfile=MYLIB/CUSTALL /clientfile=/Temp/test.xlsx  /colheadings=1  /usecollabels

image-20220715122719-2

java -Xmx1024m  -Dcom.ibm.iaccess.dataxfer.SheetId=%1$s -jar acsbundle.jar /PLUGIN=cldownload /system=MySYSTEM /hostfile=MYLIB/CUSTALL /clientfile=/Temp/test.xlsx  /colheadings=1

image-20221005104543-1

From IBM i Control Line:

/QIBM/proddata/access/acs/base

RUNJVA CLASS('/QIBM/proddata/access/acs/base/acsbundle.jar') PARM('/PLUGIN=cldownload' '/SYSTEM=localhost'  '/hostfile=MYBLIB/CUSTALL' '/clientfile=/home/MYUSER/Testscustall.xlsx' '/colheadings=0')

RUNJVA CLASS('/QIBM/proddata/access/acs/base/acsbundle.jar') PARM('/PLUGIN=cldownload' '/SYSTEM=localhost'  '/hostfile=MYBLIB/CUSTALL' '/clientfile=/home/MYUSER/Testscustall1.xlsx' '/colheadings=1')

 RUNJVA CLASS('/QIBM/proddata/access/acs/base/acsbundle.jar') PARM('/PLUGIN=cldownload' '/SYSTEM=localhost' '/hostfile=MYBLIB/CUSTALL' '/clientfile=/home/MYUSER/Testscustall2.xlsx' '/colheadings=1' '/usecollabels')     

                     

Additional Information

Document Location

Worldwide

Operating System

IBM i:All operating systems listed

[{"Type":"MASTER","Line of Business":{"code":"LOB66","label":"Technology Lifecycle Services"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SSRQKY","label":"IBM i Access Client Solutions"},"ARM Category":[{"code":"a8m0z0000000CTpAAM","label":"IBM i Access-\u003EAccess Client Solutions"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Product Synonym

AS400;IBM i;ACS;Access Client Solution;

Document Information

Modified date:
06 October 2022

UID

ibm16567579

Page Feedback