I appreciate your recommendations on a more complete style;
brevity may be the 'soul of wit' but for clarity and maintainability
it may not be a hit.
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Friday, August 23, 2013 3:44 PM
Subject: Re: View to create a PF?
On 23 Aug 2013 06:18, Hoteltravelfundotcom wrote:
How do you refer to a Temp table on the i? this is not accepted:
, COALESCE(IRLOC1,'') as IRLOC1
, COALESCE(IRLOC2,'') as IRLOC2
, COALESCE(IRLOC3,'') as IRLOC3
, '' as IEPRT#
, '.00' as IEQOH#
, '' as IELOC1
... /* <ed> indicate continuation */
) AS c_name /* <ed> concluded as one table-reference */
Somewhat moot to reply to this message because the direction of the issue since was put in the correct trajectory, but still I offer:
The "SELECT ... INTO" syntax is not what is desired there; others have already explained. The intention appears instead, to be to effect an INSERT INTO statement.
The table-reference as an implied temporary table [as a derived table expression, in parentheses, aka Nested Table Expression (NTE); although per query rewrite, may not be implemented as a temp table] is properly written; albeit I added the ellipses, the closing parenthesis, and the AS correlation-name to make the reference appear more complete. The table-expression optionally could be preceded by the keyword TABLE or LATERAL to provide emphasis or to change the available scoping of correlated names if required.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l