I'm not up on the 'G' data type, but doesn't that stand for Glob?
Anyway, on the second or third panel of the export dialogue, it has 5 or 6
options. Usually (in my case anyway) I either create based upon an existing
file or create a new file. It wasn't clear to me which option you used.
A later panel provides a scan of the spreadsheet, which gives the plug-in a
chance to figure out what data type each field is. You can change the data
type by selecting the field and pressing the Details... button. I always go
through that exercise when exporting to the System i; invariably I have to
say, "No, no, not that way!"
Jerry C. Adams
IBM i Programmer/Analyst
We are in favor of a law which absolutely prohibits the sale of liquor on
Sunday, but we are against its enforcement. 1920's Democratic platform in
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of thomas burrows
Sent: Monday, April 02, 2012 12:36 PM
Subject: Physical File "G" fields - Hope I have the correct list
If I have the wrong list please forgive and push to correct one.
When using the Client Access Express Data Transfer Excel add-in I can
automatically create a physical file on the iSeries. However, most of the
fields show are created show a "G" data type format.
1. How does one read such a field. My COBOL program is erroring out.
2. When creating the iSeries PF I have attempted to make Character fields
that are the correct length. Then run a dummy download from the iSeries to
the PC creating me a FDF file. That FDF file does not work when I try to
upload from the EXCEL spreadsheet using the Express Data Transfer Excel
Not sure what I am missing.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l