RE: ERD for Synon db without Synon?

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

There is also the Generate SQL... function in the Database section of 
iSeries Navigator. There is an option there to use ANSI/ISO syntax, which 
leaves out all the DB2/iSeries extensions, such as LABEL ON, ALLOCATE, *SYS 
naming convention, etc.

I don't know, but maybe the API has a similar option - I suspect it is used 
by Navigator but cannot confirm that.

HTH
Vern

At 03:09 PM 6/15/2005, you wrote:

> Paul, Carel,
>
> Thanks for mentioning the QSQGNDDL API. I found the Midrange Guru article at
> http://www.itjungle.com/mgo/mgo060502-story01.html
>
> Barring any prebuilt applications that can do this, I believe this is
> suitable for me to crank out the DDL. I'll probably throw it at SQL Server
> Enterprise Manager so I can define the relationships.
>
> Thanks,
> Loyd
>
> Loyd Goodbar
> Senior programmer/analyst
> BorgWarner
> E/TS Water Valley
> 662-473-5713
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Carel Teijgeler
> Sent: Wednesday, June 15, 2005 14:27
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: ERD for Synon db without Synon?
>
> 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.
>
>
>
> --
> 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.
> --
> 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.