Re: generate "create table" from PF

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Oops! Bad link. As others have correctly indicated, the right link for
RTVSQLSRC is:

http://www.mcpressonline.com/programming/cl/rtvsqlsrc.html

My apologies...

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Aug 8, 2011 at 9:14 AM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

> Jim,
>
> Scott Klement gave a link to the source code in this forum post:
>
> http://forums.systeminetwork.com/isnetforums/showpost.php?p=266601&postcount=7
>
> The link is:
>
> http://www.pentontech.com/IBMContent/Documents/article/55321_273_GenSqlDdl.zip
>
> Also, some years ago Bob Cozzi published a RTVSQLSRC command. You can find
> it here:
>
> http://www.mcpressonline.com/cl/rtvsqlsrc.html
>
>
> HTH,
>
> Luis Rodriguez
> IBM Certified Systems Expert — eServer i5 iSeries
> --
>
>
>
>   On Mon, Aug 8, 2011 at 8:40 AM, Jim Oberholtzer <midrangel@xxxxxxxxxx>wrote:
>
> > The source code link in the article does not work.  Any ideas where it
> > might be found?
> >
> > Jim Oberholtzer
> > Chief Technical Architect
> > Agile Technology Architects
> >
> >
> > On 8/8/2011 7:52 AM, Morgan, Paul wrote:
> > > Tim,
> > >
> > > Would a command that writes the SQL create statement given a PF or LF
> > work?
> > >
> > http://www.ibmsystemsmag.com/ibmi/developer/general/Generating-DDL-Source-Using-a-CL-Command/
> > > This uses the Generate Data Definition Language API.
> > >
> > > Paul Morgan
> > >
> > > Principal Programmer Analyst
> > > IT Supply Chain/Replenishment
> > >
> > > -----Original Message-----
> > > From:midrange-l-bounces@xxxxxxxxxxxx  [mailto:
> > midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of tim
> > > Sent: Sunday, August 07, 2011 11:39 AM
> > > To: 'Midrange Systems Technical Discussion'
> > > Subject: generate "create table" from PF
> > >
> > > Im looking to create some derby tables based on iseries PF. Is there a
> > > utility that will generate the "create table" sql syntax based on a PF?
> > --
> > 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.