Re: Using CPYTOARCF to create zip files to send to Linux box -- MIDRANGE-L

Add capital M to cf - that suppresses the inclusion of the manifest, which is used only by Java that I know of.

And if you have several files in a directory, you'll need more - here's what we use -

qsh cmd('jar cfM "test.zip" -C /path-of-files-to-zip .')

Here is the M to suppress the manifest. It also has the -C to change directory to where the files are you want to compress, and the period is a wildcard to include everything in that directory - I assume this wildcard could be any generic file specification.

The full quotes around test.zip might not be needed, they do work when test.zip is a more fully-qualified path name for the zip file.

HTH
Vern

On 10/16/2020 2:29 AM, Niels Liisberg wrote:

In you cl code - simply put:

qsh cmd('jar cf test.zip test.csv')

just check the 'cf' parameter and make it work for you usecase

On Fri, Oct 16, 2020 at 2:33 AM Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Laurence

You can definitely use JAR - we do it all the time to create XLSX files,
which are basically PK-zipped archives.

We wrap JAR in a QShell command - use the option to not create the
manifest - it's something like -mcf or -Mcf or the like.

HTH
Vern

On 10/15/2020 3:06 PM, Laurence Chiu wrote:

1. Found the jar utility and asked one of our IBMi users to check if it's
installed. It is. Can the jar utility be executed from a CL script which

is

what we need?
2. Can't send directly to the Linux box because it's in the cloud and the
Power server on the internal network won't allow that. The Windows box
however over a VPN

But seems that I have a solution

Thanks

On Fri, Oct 16, 2020 at 8:45 AM Jon Paris <jon.paris@xxxxxxxxxxxxxx>

wrote:

Why bother with the Wiindoze box? Just use theIBM i to send direct to

the

Linux box.

On Oct 15, 2020, at 3:27 PM, Laurence Chiu <lchiu7@xxxxxxxxx> wrote:

I need to transfer some 20G of text files each night to a Linuz server

in a

remote location. The plan is to zip all the files up, use a Windows

server

to access the Power server (on 7.3) via SSH, grab the zip file and then
SFTP to a remote location. That Linux remote location would then unzip

the

files and make them ready for an ETL process into a Data warehouse.

Some of the non iSeries guys were asking if the zip file created by

IBMi

would be compatible with standard zip files and I think they would be I
thought I would check here first.

Thanks for any feedback.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com