Re: generate "create table" from PF

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Ted Holt did a simple example a few years ago - here's that link, which 
does work - http://www.itjungle.com/mgo/mgo060502-story01.html

The API provides lots of settings you can use - to fully implement it, 
one should probably add command parameters for those items. In fact, Ted 
only specifies the name and library of PF and the destination source 
file. But it's a good start.

The API includes the following settings that can be parameterized -


Severity level
Replace option
Statement formatting option
Date format
Date separator
Time format
Time separator
Naming option
Decimal point
Standards option
Drop option
Message level
Comment option
Label option
Header option
Trigger option
Constraint option
System name option

Check the doc at http://tinyurl.com/qsqgnddl-doc-htm for explanations of 
these options.

HTH
Vern*
*
On 8/8/2011 8:10 AM, Jim Oberholtzer 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?