RE: Create DDL from exiting PF&LFs

iSeries Navigator has the functionality built in.  Under "Databases", expand 
schemas (libraries), then tables (PF) or views(LF).  Right click on your 
selected table or view and select "Generate SQL".  You can also right click and 
select "Generate SQL" on a schema to generate an SQL script for everything in 
the schema. 

In addition, there are APIs you can use to roll your own program.


HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx
> [mailto:midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx]On 
> Behalf Of
> Dimitri Efimov
> Sent: Friday, July 01, 2005 5:13 PM
> To: Midrange Systems Technical Discussion
> Subject: Create DDL from exiting PF&LFs
> 
> 
> 
> 
> We have been told by IBM that recreation our files with SQL 
> could give as a great of read-performance improvement 
> (chain-read is about 90% of operations or our programs).
> 
> Do anyone have en information about a tools to create SQL 
> tables & indexes. taking information from existing files?
> 
> Dmitri Efimov
> Banco Wiese Sudameris
> Peru, Lima
> 
> 
> Aviso Banco Wiese Sudameris
> 
> Este mensaje es privado y confidencial y solamente para la
> persona a la que va dirigido. Esta sujeto a los terminos que
> aparecen en  http://www.bws.com.pe/aviso.shtml los cuales
> forman parte de su contenido.
> 
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>