RE: Create DDL from exiting PF&LFs

Thanks,

iSeries Navigator is not allowed in our system (IT Security department prohibit 
everything they don't understand). But Ted's tools works just great. And it's 
more useful for batch mode - we have to rebuild about 15000 objects.

Cheers,

Dmitri


-----Mensaje original-----
De: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]En nombre de Wilt, Charles
Enviado el: Viernes, 01 de Julio de 2005 05:03 p.m.
Para: Midrange Systems Technical Discussion
Asunto: 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.
>
>

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


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.