tags:

views:

10

answers:

0

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???