1. It generates a CSV file on your Windows PC. It can generate other
file types, also. Including XLSX Excel files.
2. It doesn't have the CPYTOIMPF parameters - it has various file types
as parameter. It does have a checkbox where you choose whether to
include column headings.
3. So it does let you choose to have the full column heading text - it
uses the entire column heading values, each row with enough spaces to
make 20 characters per row. Maybe like this, which is the output of
DSPFD *MBR, I believe -
"Retrieval Century","Retrieval Date","Retrieval
Time","File","Library","Type Of File","File
Attribute","Reserved","File Attribute","System
Name","ASP Auxiliary Storage Pool
ID","Reserved","FILETYPE File Type","WAITFILE
Maximum File Wait Time","WAITRCD Maximum Record
Wait Time","Reserved","LVLCHK Record Format Level
Check","TEXT Text 'Description'","Number Of
Record Formats","Century Created","Date
Created","Time Created","Externally Described","DBCS
Capable","Reserved","Access Path","S/O
Select/Omit","Alternative Collating
Sequence","Number Of Members","JFILE Join
File","Reserved","Member","Member Creation
Century","Member Creation Date","Member
Creation Time","Expiration Century","EXPDATE
Expiration Date","Member Text
Description","Reserved","Reserved","Reserved","MAXMBRS
Maximum Members","MAINT Access Path
Maintenance","RECOVER Access Path
Recovery","FRCACCPTH Force Keyed Access
Path","Maximum Key Length","Maximum
Record Length","File Is Currently
Journaled","Current Or Last Journal","Journal
Library","Journal Images","Century Of
Last Journal","Date Of Last Journal","Time
Of Last Journal","Initial Member
Size","Increment Number Of Records","Maximum
Number Of Increments","Current Number Of
Increments","Record Capacity","Current Number Of
Records","Number Of Deleted Records","ALLOCATE
Allocate Storage","CONTIG Contiguous Storage","UNIT
Preferred Storage Unit","FMTSLR Record
Format Selector Program","FMTSLR Library","FRCRATIO
Records To Force A Write","SHARE Share
Open Data Path","DLTPCT","Data Space Size","Index
Size","Index Entries","Number Of Member
Accesses","Source Type","Last Change
Century","Last Change Date","Last Change
Time","Last Update Century","Last Source
Update","Last Update Time","Extract
Century","Extract Date","Extract Time","Last
Extract Century","Last Extract
Date","Last Extract Time","Last Save
Century","Last Save Date","Last Save
Time","Last Restore Century","Last Restore
Date","Last Restore Time","Number
Of Members Accessed By Logical File","Physical
File","Library","Member","Logical File Format","Index
Entry Count","Member Access
Count","OMTJRNE Journal Entries To Be
Omitted","Implicit Share Type","Implicit Share
File","Implicit Share Library","Implicit Share
Member","Implicit Share Maintenance","Implicit
Share Recovery","Implicit Share Force Keyed Access
Path","Implicit Share Keys Must Be
Unique","Access Path Journaled","Allow
Read Operation","Allow Write Operation","ALWUPD
Allow Update Operation","ALWDLT Allow Delete
Operation","Source Type","Last Used Century","Last
Used Date","Days Used Count","Usage Data
Reset Century","Usage Data Reset
Date","Access Path Valid","Data Space Size","Maximum
Key Length","Open Operations","Close
Operations","Write Operations","Update Operations","Delete
Operations","Logical Reads","Physical
Reads","Clear operations","Data Space Copy
Operations","Reorganize Operations","Access Paths
Builds/Rebuilds","Records Rejected By Key Selection","Records
Rejected By Non-key Selection","Records Rejected
Group-by Selection","Access Path Logical
Reads","Access Path Physical Reads","Index
Size","Storage Freed","Unique Encoded
Vector Key Values","Unique Key Values Key
Field 1","Unique Key Values Key Fields
1-2","Unique Key Values Key Field
1-3","Unique Key Values Key Field 1-4","Number
of Overflow Key Entries","Partial
Transaction","Starting Journal Receiver","Library
Containing Journal Receiver","Journal Receiver
ASP Device","Roll Back
Ended","Century MQT Refreshed","Date MQT
Refreshed","Time MQT Refreshed","Number Of
Members Accessed By Logical File"
"1","210302","080200","QQMQRYSRC","UPERSON1","P","*PHY","","PF","SYSTEM1",1,"","S",-1,60,"","N","",1,"1","200920","142944","Y","N","","A","N","N",1,"","0","CUSTOMER","1","200920","142953","*","NONE","","","","",0,"","","",0,91,"N","","","","","","",10000,1000,499,0,509000,3,0,"N","N",0,"","",0,"N",0,8192,0,0,0,"","1","200920","142953","1","200920","142953","","","","","","","1","200926","134134","","","",0,"","","","",0,0,"","","","","","","","","","","Y","Y","Y","Y","","1","200920",1,"","","",8192,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,0,"0","","","","0","1","200920","142953",0
On 3/23/2022 11:19 AM, jerry ven wrote:
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
midrange.com
