re:how to create files in DDL format on Iseries

I believe that DDL stands for Data Definition Language.  Which means that 
instead of using DDS, which is proprietary to the iSeries you can use the 
traditional SQL.  Therefore you can use statements like
Create Table Customer
     ( CustID     Dec(    7,0 ) Not Null,
       Name       Char(  30   ),
  Primary Key( CustID ) )

There are several methods of storing these scripts.
1)  Don't.  Run it on the fly.  You can always restore or copy the file.
2)  Use iSeries Navigator
3)  Store them in a member in a file and use RUNSQLSTM
...

For more information check out the manual "SQL Reference" available at:
http://publib.boulder.ibm.com/html/as400/infocenter.html

Or the book "SQL/400 Developer's Guide" by Paul Conte and Mike Cravitz 
available at
http://store.midrange.com/books.htm

Rob Berendt
-- 
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)




"Ali Ekinci" <Ali.Ekinci@xxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/05/2003 12:29 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
re:how to create files in DDL format on Iseries






Does anybody know how to create database files in DDL format on Iseries?
Any link, or documentation would greatly be appreciated.
Thanks in advance for any help.
Ali

_______________________________________________
This is the RPG programming on the AS400 / iSeries (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.