Re: Dynamic SQL - From clause

["Knapp, Richard" <KnappR@UMSYSTEM.EDU>]

Hmmmm.  My documentation is for 4.3 and I can't find mention of this feature. 
I'm assuming that it would be discussed either in the begin-select, begin-sql 
or dynamic SQL sections.  I'm looking in both the 'Language Reference' and 
'User Guide'.

I hate to trouble you, but could you say, rather than the page number, what 
section of what manual the discussion occurs in?

Many Thanks.

Richard

-----Original Message-----
From: Peter Burton [mailto:pburton@BRIO.COM]
Sent: Wednesday, October 02, 2002 8:49 AM
To: SQR-USERS@list.iex.net
Subject: Re: Dynamic SQL - From clause


Richard,

I would guess since version 2.x (~1989).

The earliest book I have is from SQR 3 and this feature is discussed on Page
51.

Page

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@UMSYSTEM.EDU]
Sent: Wednesday, October 02, 2002 9:34 AM
To: SQR-USERS@list.iex.net
Subject: Re: Dynamic SQL - From clause


Peter,

What version of SQR does this feature appear in?

Thanks,

Richard Knapp
Database Programmer/Analyst
Administrative Systems Project
University of Missouri System
573-884-3157
knappr@umsystem.edu


-----Original Message-----
From: Pamela Lantzy [mailto:PLantzy@UAMAIL.ALBANY.EDU]
Sent: Wednesday, October 02, 2002 7:26 AM
To: SQR-USERS@list.iex.net
Subject: Re: Dynamic SQL - From clause


Thanks for the explaination

-----Original Message-----
From: Peter Burton [mailto:pburton@BRIO.COM]
Sent: Tuesday, October 01, 2002 6:58 AM
To: SQR-USERS@LIST.IEX.NET
Subject: Re: Dynamic SQL - From clause


Pamela,

The [{table_name}:$Table_name] construct directs SQR to use {table_name} at
compile time to validate the BEGIN-SELECT paragraph and uses the contents of
$Table_name at runtime.

Peter

-----Original Message-----
From: Pamela Lantzy [mailto:PLantzy@UAMAIL.ALBANY.EDU]
Sent: Tuesday, October 01, 2002 6:23 AM
To: SQR-USERS@list.iex.net
Subject: Dynamic SQL - From clause


I have seen this in a couple SQRs, but I am not sure what this does.


FROM [PS_COMMUNICATION:$table] V

$table gets populated with a different table name.  There isnt a comma to
separate the 2 tables.  In the where clause there is nothing that joins
these 2 tables together.

Is if $table is not assigned a table name then it will use PS_COMMUNICATION
as an alternative, but if $table is assigned, it will use that and ignore
PS_COMMUNICATION?


I couldnt find any explainations of using : in the from.

Thanks.
Pam