It's all about the answers!

Ask a question

How to manage, with iseries, a DTAARA and a RUNSQLSTM ?


Bernard Brochu (111) | asked Nov 04 '11, 10:22 a.m.
retagged Jun 24 '12, 3:53 a.m. by Arne Bister (2.6k12732)
Those command can not be compiled, and inside a Build generation, I don't know how to manage it?

Thanks,
Bernard Brochu

One answer



permanent link
jeff tickner (51710) | answered Oct 02 '12, 6:00 p.m.
 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. 

Your answer


Register or to post your answer.