×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
