Re: [Re: Question: Dynamic Table with Join]

[Vishal Nayak <vishme@NETSCAPE.NET>]

Hi !

I am not really sure, but I have a feeling that the 'v' should be inside the
variable  $var_table, I guess that is causing the trouble....
if this din't work, you may also want to try :

   move 'tablename' || '  v ' to $var_table
and then proceed to include this as [$var_table] in your dynamic query.

hope that helps..

Vishal.

owner-sqr-users@list.iex.net wrote:
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


____________________________________________________________________
More than just email--Get your FREE Netscape WebMail account today at http://home.netscape.com/netcenter/mail