Yeah, that's pretty much it. The easiest way to create the DDL is via System i Navigator under the Database/Schema tree. After you create the table, you can right click on the table and use the Generate SQL source. One of the options is to save it to a source member. I always save them to their own source physical file and apply a source type of SQL. One can then use the RUNSQLSTM to execute these (or other) SQL statements.
Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Deskevich
Sent: Wednesday, April 29, 2009 3:51 PM
To: IBM i / System i
Subject: Confused about DDL and DDS
I have been searching through the archives and the web.
I want to create a data base file using DDL. Is DDL just a text file created with PDM with a CREATE statement in it? I did not see any examples anywhere except CREATE statements. I never saw the equivalent of DDS for the CREATE to look at.
I do not see a source type DDL in PDM.
Signed, confused in Ebensburg...
Tom Deskevich
Infocon Corporation
Phone 814-472-6066
Fax 814-472-5019
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2026 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.
midrange.com
