Re: AW: Can't call QSQGNDDL on a V7R2M0 box.

What version of the OS are you running on your IBM i?

If you point a browser to
http://youribmi:2001
You will get to "IBM Navigator for i".
Expand Database.
Expand Databases. You will likely only have one and it will be named
after the IBM i. Expand that.
Expand Schemas. You will have a few shown. But not all. Normally what
is shown is what is in your default library list. However, if instead of
expanding schemas, you click on Schemas you will have an "Actions" box.
One of the options in Actions is "Select schemas to display".
Pick a schema containing the table(s) you want to generate SQL for.
Back off to the left you can expand that schema.
Click on Tables.
Checkmark a table. From the "Actions" box select "Generate SQL"

This will be the replacement product for the iNav fat client that others
are recommending.

Sample generated SQL:
-- Generate SQL
-- Version: V7R2M0 140418
-- Generated on: 07/20/15 09:24:30
-- Relational Database: GDISYS
-- Standards Option: DB2 for i
CREATE TABLE DARREN.@WK (
WKYEAR NUMERIC(4, 0) NOT NULL DEFAULT 0 ,
-- SQL150D 10 EDTCDE in column WKYEAR ignored.
WKWEEK NUMERIC(2, 0) NOT NULL DEFAULT 0 ,
-- SQL150D 10 EDTCDE in column WKWEEK ignored.
WKDATE NUMERIC(8, 0) NOT NULL DEFAULT 0 )

RCDFMT @WKR ;

LABEL ON TABLE DARREN.@WK
IS 'Week No.''s/Dates Cross-Ref' ;

LABEL ON COLUMN DARREN.@WK
( WKYEAR IS 'Year Num' ,
WKWEEK IS 'Week Num' ,
WKDATE IS 'Date' ) ;

LABEL ON COLUMN DARREN.@WK
( WKYEAR TEXT IS 'Year No.' ,
WKWEEK TEXT IS 'Week No.' ,
WKDATE TEXT IS 'Date of first day of week' ) ;

GRANT ALTER , DELETE , INDEX , INSERT , REFERENCES , SELECT , UPDATE
ON DARREN.@WK TO DARREN WITH GRANT OPTION ;

GRANT INSERT ( WKDATE , WKWEEK , WKYEAR ) , REFERENCES ( WKDATE , WKWEEK ,
WKYEAR ) , SELECT ( WKDATE , WKWEEK , WKYEAR ) , UPDATE ( WKDATE , WKWEEK
, WKYEAR )
ON DARREN.@WK TO PEGGY WITH GRANT OPTION ;

GRANT INSERT ( WKDATE , WKWEEK , WKYEAR ) , REFERENCES ( WKDATE , WKWEEK ,
WKYEAR ) , SELECT ( WKDATE , WKWEEK , WKYEAR ) , UPDATE ( WKDATE , WKWEEK
, WKYEAR )
ON DARREN.@WK TO PUBLIC WITH GRANT OPTION ;

GRANT INSERT ( WKDATE , WKWEEK , WKYEAR ) , REFERENCES ( WKDATE , WKWEEK ,
WKYEAR ) , SELECT ( WKDATE , WKWEEK , WKYEAR ) , UPDATE ( WKDATE , WKWEEK
, WKYEAR )
ON DARREN.@WK TO ROB WITH GRANT OPTION ;

GRANT ALTER , DELETE , INDEX , INSERT , REFERENCES , SELECT , UPDATE
ON DARREN.@WK TO SSA WITH GRANT OPTION ;



Rob Berendt