Thanks Martin. That works perfectly. This was on Unidata in U mode.
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
"Martin Phillips" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/24/2008 02:21 AM
Please respond to u2-users
To: <[email protected]>
cc:
Subject: Re: [U2] WITH Clause
Hi Charles,
> Can parenthesis be used to group WITH statements? I am modifying a
> humongous SORT statement with many WITH clauses and would like to group
> them. If so, what are the rules?
>
> WITH (COND1 OR COND2) AND WITH (COND3 OR COND4) ?
>
> (WITH COND1 OR WITH COND2) AND (WITH COND3 OR WITH COND4) ?
Preferably, omit the repeated WITH so that the second example above
becomes
WITH (COND1 OR COND2) AND (COND3 OR COND4)
The semantics of multiple WITH clauses is different depending on the
UniVerse flavour in use.
Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
