Re: generate "create table" from PF

I have not seen any suggestion about using iNav's "Generate SQL..." function
in the Database tab.  Did I miss something that would preclude its use?

Jerry C. Adams
IBM i Programmer/Analyst
My wife doesn't understand me, but I'll bet Mrs. Einstein didn't understand
Albert either.
--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Monday, August 08, 2011 8:33 AM
To: Midrange Systems Technical Discussion
Subject: 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-Us
ing-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.

--
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.