my @query = ( [DECLARE GLOBAL TEMPORARY TABLE SESSION.temp SELECT id FROM mytable ON COMMIT PRESERVE ROWS WITH NORECOVERY, "/dev/null"], ["SELECT name FROM SESSION.temp WHERE id=? AND salary >= 1","csvfile2_$id.csv"], }