RE: Physical File "G" fields - Hope I have the correct list

Thomas,

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
615-867-5070


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

Questions:
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
Add-in.

Not sure what I am missing.

Thomas
--
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,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.