How to manage, with iseries, a DTAARA and a RUNSQLSTM ?
One answer
The Arcad Power Pack provides a compile option for SQL source that will execute RUNSQLSTM.
You just need to set the member attribute to indicate what the generated object is, TABLE, VIEW, INDEX, SQLPRC, SQLUDF.
Arcad will manage dropping the object if it already exists and also manage the data in a TABLE.
The compile command is available from the iProject under remote actions and is executed during the build by the Arcad build process.
http://public.dhe.ibm.com/common/ssi/ecm/en/rab14064usen/RAB14064USEN.PDF
The Power Pack will also manage objects it finds in the build library.
We have a freeware Data Area editor that is in beta that can be used to create data areas from RDP.