I have the following SQL script with two unload statements:
UNLOAD TO "actives.unl"
SELECT *
FROM table1 AS t1
WHERE t1.status = "A"
ORDER BY t1.fk_id;
UNLOAD TO "inactives.unl"
SELECT *
FROM table1 AS t1
WHERE t1.status = "I"
ORDER BY t1.fk_id;
When I execute the script from within ISQL's QueryLanguage Menu it works fine, but when I add this script as a menu option in SYSMENUITEMS and execute it from within the User-Menu, the two unload statements execute but unload 0 rows. I went back to my perform screen and queried table1 and all the rows were there???