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



RUNSQLSTM will ask you for the source member

Tom Deskevich escribió:
Ok, how do you 'run' that then to actually create the table?

I am assuming you are using SQL type in PDM for documentation purposes only.
It is not listed when you press help to see all the types.

Then when you want to do the equivalent of CHGPF to add or change a column
in the table , you do an ALTER TABLE?

Tom Deskevich
Infocon Corporation
Phone 814-472-6066
Fax 814-472-5019


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Loyd Goodbar
Sent: Wednesday, April 29, 2009 3:04 PM
To: RPG programming on the IBM i / System i
Subject: Re: Confused about DDL and DDS


Yes, DDL is "just" text. I use the "SQL" type in PDM (well, Aldon does when
I create the member).

Here is an excerpt from a table DDL:

create table fsicapture (
capturedate for column capdate date not null with default,
isshipday decimal(1,0) not null with default,
...
budget decimal(12,2) not null with default,

primary key (capturedate)
)
rcdfmt fsicapturr
;

label on table fsicapture is 'Forecast sales inventory graph capture';

label on column fsicapture (
capturedate text is 'Capture date',
isshipday text is 'Is ship day 1=yes',
...
budget text is 'Sales budget for month'
);

label on column fsicapture (
capturedate is 'Capture Date',
isshipday is 'Shipping Day 1=Yes 0=No',
...
budget is 'Sales Budget'
);

alter table fsicapture
add constraint check_isshipday check(isshipday in (0,1))
;


HTH,
Loyd


On Wed, Apr 29, 2009 at 3:51 PM, Tom Deskevich <
thomas.l.deskevich@xxxxxxxxxxxxx> wrote:


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.



--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.







As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.