Re: INTO TEMP clause

In article <20sfh5$d01@spool.mu.edu> gidwani@studsys.mscs.mu.edu (Vinay Gidwani) writes: >I have a query :- > >SELECT inventory.store_no, inventory.location, inventory.tag_id >INTO TEMP invtemptab >FROM inventory WHERE>inventory.location NOT MATCHES "910-*" >AND inventory.store_no IN > (SELECT wave_schedule.store FROM wave_schedule > WHERE wave_schedule.wave = wv_no) > >I am getting error no: -4369 > >The symbol variable-name does not represent a defined variable. > >According to the manual this seems to be the proper way to do it. >Any help will be appreciated. > >Vinay. > >email gidwani@studsys.mscs.mu.edu Try it with the INTO TEMP clause at the end, i.e.: SELECT inventory.store_no, inventory.location, inventory.tag_id FROM inventory WHERE inventory.location NOT MATCHES "910-*" AND inventory.store_no IN (SELECT wave_schedule.store FROM wave_schedule WHERE wave_schedule.wave = wv_no) INTO TEMP invtemptab when you are selecting into a program variable, you put the "INTO p_store_no" after the SELECT but before the FROM, but "into temp some_table" always comes at the end. Paul