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.