Re: Confused about DDL and DDS

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

DDL means Data Definition Language - it is not a source type - you 
create a source member which you then specify on a RUNSQLSTM command. 
That member can really have any source type - PDM does not care or use 
it, AFAIK. I often use SQL for the source type.

DDL includes all the CREATE, ALTER, DROP, etc., statements. The SQL 
Reference can tell you what they are - or just google on DDL and you 
should find something.

Now SQL has another set of statements, known as DML - Data Manipulation 
Language - things like SELECT, UPDATE, DELETE, etc.

I just learned at COMMON that when you use RUNSQLSTM to create a table, 
that source member information is stored in the object description - 
just as it is when creating something from DDS - way cool!!! Of course, 
all you others already knew that!

HTH
Vern

Tom Deskevich 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. 
>
> Signed, confused in Ebensburg...
>
> Tom Deskevich
> Infocon Corporation
> Phone 814-472-6066
> Fax 814-472-5019
>
>