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
Syracuse, NY
A&K Wholesale
Murfreesboro, TN

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of thomas burrows
Sent: Monday, April 02, 2012 12:36 PM
To: MIDRANGE-L@xxxxxxxxxxxx
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

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].