Kbase 2965: using ... in ( list ) in HLI and getting error (247)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
using ... in ( list ) in HLI and getting error (247)
900919-mlb02In dynamic SQL, if a user creates a view using an
IN ( list ) option where the list is not delimited
with blanks, the user will get an error, as in:
create view x as select cust-num,name,city,st from
customer st in ('MA','VT','NH','RI','ME','CT')
SQLCODE = -1
*** Unable to understand after -- ",RI,ME,CT)". (247)
but this works:
create view x as select cust-num,name,city,st from
customer st in ( 'MA' , 'VT , 'NH' , 'ME' , 'CT' )
This is a bug in all v6.2a and above on all platforms
and will be fixed in all future releases of v6.
Progress Software Technical Support Note # 2965