Re: Can we FTP a CSVF file to local desktop in good format

I was able to generate column heading by creating view as referred in this
IBM link :-*https://www.ibm.com/support/pages/adding-column-headings-cpytoimpf-output-streamfiles
<https://www.ibm.com/support/pages/adding-column-headings-cpytoimpf-output-streamfiles>*

1. So can IBM i ACS tool be used to generate CSV file directly as output
file?

2. If Yes, will it have all the conditions which are given while generating
the CSV file using CPYTOIMPF command ( for example RCDDLM(*CRLF)
STRDLM(*NONE) etc.) ? and we don't need CPYTOIMPF command any more ?

3. So the output file generated using IBM i ACS tool as a CSV file will
have all the full column text(headings in full detail of all the fields)
and no need to create View etc. to get full details of column headings for
CSV file ?



Thanks.





On Wed, 23 Mar 2022 at 21:17, Patrik Schindler <poc@xxxxxxxxxx> wrote:

Hello Jerry,

Am 23.03.2022 um 16:05 schrieb jerry ven <jerryven95@xxxxxxxxx>:

But unable to download it with full text in the column headings (which

is present in the base physical file from which his CPYTOIMPF gave output
in a csv file format which is present at IFS location.

Physical files usually contain the field description. But that's not the
same als a simple flat file containing a list of field names in the first
line.

You mentioned, it's not possible to add column headings to an import file
(text file in the IFS) with your release of OS/400.

It's still not clear what your problem is. Every other mail, you add a new
topic, stacking up a pile of confusion.

Are you "just" missing column headings?

Are you seeing "garbage" in the downloaded import file? If yes, did you
use binary or ascii mode to download this via FTP?

Of does your download not work at all? If not, what is the error message
you're getting? "Does not work" is *not* a proper problem description.

I more and more think that whatever you want to achieve is partly not
possible (as Alan pointed out), or done plainly wrong (because of missing
skills?) and you should probably come up with other ways to achieve your
goal.

Is this a one-shot thing, or is this download of data to happen regularly?

:wq! PoC

--
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