Re: generate "create table" from PF

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?