Re: Question: Dynamic Table with Join

[Moore Anthony B <Anthony_B_Moore@BSCC.BLS.COM>]

TRY
------

move 'tablename' to $var_table


BEGIN_SELECT


  FROM       alpha a,
                beta  b,
                [$var_table] v
     WHERE ...



OR TRY THIS
------------

if XXXXXX =  XXXXX
  then
  move 'tablename' to $var_table
 else
   move 'tablename2' to $var_table


BEGIN_SELECT

FROM       alpha a,
                beta  b,
                [$var_table] v
     WHERE ...



-----Original Message-----
From: Bill Moody [mailto:wmoody@CCMAIL.MULLER.COM]
Sent: Monday, December 28, 1998 11:09 AM
To: Multiple recipients of list SQR-USERS
Subject: Question: Dynamic Table with Join


     Hi,

     I am using sqr 2.4.1 on HP-UX against Oracle 7.3.
     I am trying to pass in a table name, create the table, use sqlldr to
     populate it, run the query and finally delete the table.

     I cannot create the table. I cannot hard code the table name, it's
     a short lived temp table so it has to be a variable.

     Every example uses only one static table and one variable table.
     I need to use more than one table, e.g.,

     ...
     FROM       alpha a,
                beta  b,
                [static v: $var_table] v
     WHERE ...


     I've tried many variations on this theme.

     Any help is appreciated. Thanks in advance.

     Bill Moody