Re: ERD for Synon db without Synon?

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Lloyd,

An example that uses this API (RPG IV) can be found at www.itjungle.com. It was 
written by Ted Holt,and was published with the Guru-newsletter a couple of 
months ago. Unfortunately, I cannot  recall the date.

Regards,
Carel Teijgeler 

*********** REPLY SEPARATOR  ***********

On 15-6-05 at 14:55 Paul Morgan wrote:

>Check out the Generate Data Definition Language API (QSQGNDDL) found in the
>Database & File APIs.  This API can retrieve the SQL DDL (CREATE TABLE,
>CREATE VIEW and such) for any file even if created using DDS.  Use this API
>on the Synon files then strip out the field prefixes from the SQL source.
>With some modifications that SQL could be used in Enterprise manager.
>
>I've got a RTVSQLSRC CMD/CL front end for this API that might be helpful.
>Would be happy to post the source or maybe someone could offer to host it for 
>download.