Problem editing SQL in information link to add a inserts statement

I am trying to replicating ideas from TAAM June 2015 to modify an IL to include an INSERT statement before the SELECT statement.

I have tried many things and I cannot make an insert statement work In the query section on an IL. I can run it in the Pre-Updates section if I leave off the semicolon. However it seems that in the Pre-updates section I cannot use parameters.

Has anyone suceeded in adding an isert staement before the select in an ionformation link? I suspect a product change has made this impossible.


(1) Answer