Kbase P96694: SQL-92: Can a Table be created ON-LINE with CREATE TABLE statement together with SELECT phrase?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/10/2004 |
|
Status: Unverified
GOAL:
Using JDBC or ODBC Client
GOAL:
Creating table using CREATE TABLE statement together with SELECT phrase to populate data
ex: create table mytable a select name from pub.customer where country = 'USA';
GOAL:
Table created while the Database is in use by another concurent user (using Online Schema Change)
GOAL:
Is CREATE TABLE supported in this scenario?
FACT(s) (Environment):
OpenEdge 10.0x
FIX:
No, with the current implementation of ALTER TABLE, it is not supported to CREATE TABLE on line with SELECT phrase to populate data in it