Re: Dynamic file and fields

[rbaird@xxxxxxxxxxxxxxxxxxxxx]

Jonathan,
You can build the sql statement to "create table" yourself -
use the sql given to you by Rolf, just replace the eval of sqlstm with
something like this:
C                   eval      sqlStm = 'create table ' +
C                                %trim($libraryname) + '/' +
C                                %trim($filename) + '('    +
C                                %trim($fld1) +
C                                %trim($fld1typ) + '(' +
C                                %trim($fld1len) + '), ' +
C                                %trim($fld2) +
C                                %trim($fld2typ) + '(' +
C                                %trim($fld2len) + ')) '

You will of course have to supply the logic as to how you populate $fld1xxx
fields.

original message:

>BTW, Is there a way on how to create a dynamic PF and field using SQLRPGLE
>or any AS/400 programs without hard coding the table name and its fields.
>I tried to do this by CREATE TABLE but i don't know if it has a capability
>to not hard code the table and fields but instead assign a table name
>or field name ?


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---