step by step:

1. after understanding the example you create a temporary table
   • by own hands
2. then you compose a SQL query to feed your Resultset
   • by own hands
3. with your query you create a %SQL.Statement
   • by own hands
4.  running %Execute generates %SQLStatementResult

BINGO
 You may publish your code on OpenExchange as an example.

But this question is Caché 2016  at its10th birthday !   Not IRIS 2015.*

not ARCHIVE, rather name it MUSEUM.

if you find bones of a dinosaur nobody would expect to raise a full beast

It will be deposited in a museum as an historic artefact instead