Nathan,
I've written such programs years ago on the S/36. But it's only good for a
start; i.e., usually one cannot take this info and automagically convert
files.
Typical reasons include (a) the file names in an RPG II program oftentimes
have no direct relationship to the name on disk (anyone remember group
files, as a simple example), and (b) RPG II programs were used to splitting
fields into smaller elements (date = mm, dd, and yy fields, for example).
Multi-format flat files make this even more error prone. Doable, as you
say, but not worth the expense when there are already utilities out there
that do this.
Jerry C. Adams
IBM i Programmer/Analyst
You're not fat. You're just easy to see.
--
A&K Wholesale
Murfreesboro, TN
615-867-5070
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Nathan Andelin
Sent: Friday, March 16, 2012 11:53 PM
To: RPG programming on the IBM i / System i
Subject: Re: accessing QS3F data by utilities and 4GLs - where do they see
thefield layout ?
If you think about it, most of what you need to externally define your files
is in the "I" specs. Record name, field name, field type, field length can
be derived from starting and ending positions, and decimals.
http://www.radile.com/rdweb/temp/gl100.txt
It would be pretty easy to write a program to harvest "I" specs from RPG II
source members and import them into a data dictionary. Then you could then
generate DDS or SQL DDL. You'd still need to enter column headings and any
other meta data you'd want.
----- Original Message -----
From: Jim Franz <jfranz@xxxxxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Cc:
Sent: Friday, March 16, 2012 7:21 PM
Subject: Re: accessing QS3F data by utilities and 4GLs - where do they see
thefield layout ?
there are several s36 to native conversion tools that work with RPGII F&I.
Google "s36 to native conversion" for a list. From there you have native dds
files accessible from sql tools (have to work around multi record format
and multi member files). And there are services that do this for a fee.
Jim Franz
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
