× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



QSQGNDDL is the API for this, and is the same API used by Navigator. i
have a command built around this that can be downloaded from my website in
the downloads section http://tommyholden.com


Thanks,
Tommy Holden




From:
rob@xxxxxxxxx
To:
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Date:
07/28/2009 08:25 AM
Subject:
RE: CHGPF and ALTER TABLE
Sent by:
rpg400-l-bounces@xxxxxxxxxxxx



See, if this was on midrange-l, where it belongs, you would have probably
received the answer by now that you can easily retrieve the SQL used to
create the file

CREATE TABLE ROB/JERRYA
(MYFIELD CHAR (5 ) NOT NULL WITH DEFAULT,
COLUMNA CHAR (2 ) NOT NULL WITH DEFAULT)

ALTER TABLE ROB/JERRYA
ADD COLUMN BUBBA DEC (5 , 0) NOT NULL WITH DEFAULT

Then you can use iNav's Generate SQL Scripts to retrieve:
-- Generate SQL
-- Version: V6R1M0 080215
-- Generated on: 07/28/09 09:17:35
-- Relational Database: GDIHQ
-- Standards Option: DB2 i5/OS
CREATE TABLE ROB.JERRYA (
MYFIELD CHAR(5) CCSID 37 NOT NULL DEFAULT '' ,
COLUMNA CHAR(2) CCSID 37 NOT NULL DEFAULT '' ,
BUBBA DECIMAL(5, 0) NOT NULL DEFAULT 0 )
;

There's gotta be an api out there to do the same.

As part of your process you could easily incorporate this.



Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.