Re: Creating dynamic fields in a Physical file

Paul,

You should be able to use describe to get the field types and
attributes
and then run a create table. The iSeries-toolkit at
www.iseries-toolkit.org
has a CRTDBF command that uses this technique. It will take a select
statement and then generate a database file for the results.

So running CRTDBF DBF(mylib/myfile) SQLSTM('select * from
somefile join anotherfile on somefile.key = anotherfile.key
where selfield = 'xxx')

Results in a file being created named myfile in mylib that contains
the results of the select. It will recognize functions etc., so you can

actually convert the type of a field. It does not generate DDS, but
uses Create Table. The source is included and you could modify
it to generate the dds,

David Morris


>>> qppaul@mmm.com 05/09/02 02:12AM >>>
--
Is it possible to create a physical file with n number of fields
dynamically.

No of fields will be determined by SQLRPGLE program.

Regards
Paul.