Kbase P126334: Does SQL-92 support using column renaming with the NextVal function?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/11/2007 |
|
Status: Unverified
GOAL:
Does SQL-92 support using column renaming with the NextVal function?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
FIX:
The use of the 'AS <SomeNewColumnName>' phrase is not currently supported with the NEXTVAL function. It is not possible to use a SELECT statement like the following:
SELECT PUB.SomeSequence.NEXTVAL AS MySequence FROM PUB.SomeTable