Re: SQL in SQR

[the dragon <ceprn@HOTMAIL.COM>]

show us the code you're attempting to use to create multiple tables.

clark 'the dragon' willis
dragon enterprises, consulting services


----Original Message Follows----

I'm trying to create temp tables in my SQR program.  It will allow me to
create one, but I can't seem to get it to create more than one.  My ultimate
goal would be to have a a multi-module program where I select different
things from different tables and then insert them into the various temp
tables.

Do you know if you can create more than one temp table in a SQL paragraph in
SQR?

My temp table create statement looks like this:

begin-setup
page-size 56 132

BEGIN-SQL  ON-ERROR=SKIP

   CREATE TABLE PMCGEN_TEMP (GENERIC_NAME    VARCHAR2(40))
      TABLESPACE USER_ACCOUNTS
         STORAGE
         (INITIAL     5000K
          NEXT         500K);
end-sql
end-setup

and the insert statement looks like this:

begin-procedure INSERT_TEMP
BEGIN-SQL
INSERT INTO PMCGEN_TEMP (GENERIC_NAME)
values (&GEN);
END-SQL
COMMIT
end-procedure


That works fine.  But, I've tried to add another create table... and insert
into... and I get the message:  "table for view does not exist" for the
second table.


Thanks,


Jenny

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com