How to run a SQL script in ADS.

I am trying to run the following SQL code in Aqua Data Studio for an Informix Database:

DEFINE  testVal    integer

FOREACH WITH HOLD

    SELECT test_val

    INTO testVal

    FROM tmp_values

    BEGIN WORK;

        DELETE FROM data_values

        WHERE data_Val = testVal

    COMMIT WORK

 END FOREACH

I would also like to display the value of 'testVal' every iteration (or maybe every Nth iteration). 

For the life of me I can’t get it to work.  I’ve looked on your web site and on-line but I have found nothing helpful. 

Any help would be greatly appreciated.