|
Home > Archive > SQL Anywhere database > June 2005 > ASA 9.0.2: bug ore feature?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ASA 9.0.2: bug ore feature?
|
|
| Andrei Iliev 2005-06-15, 7:23 am |
| Dbunload utility omits PCTFREE option in CREATE TABLE statement. Unload
database wizard in Sybase Central gives same result.
Example:
CREATE TABLE foo1 (
id_foo INTEGER NOT NULL PRIMARY KEY,
foo_name CHAR(80),
PCTFREE 0
);
Running dbunload utility gives the following command script:
CREATE TABLE "DBA"."foo1"
(
"id_foo" integer NOT NULL ,
"foo_name" char(80) NULL ,
PRIMARY KEY ("id_foo"),
)
Look, PCTFREE parameter is disappeared.
Andrei Iliev
| |
| Chris Keating \(iAnywhere Solutions\) 2005-06-15, 7:23 am |
| I think this is a bug and have reported it to engineering.
"Andrei Iliev" <xzxz@mail.ru> wrote in message news:42affe47@forums
-1-dub...
> Dbunload utility omits PCTFREE option in CREATE TABLE statement.
> Unload
> database wizard in Sybase Central gives same result.
> Example:
> CREATE TABLE foo1 (
> id_foo INTEGER NOT NULL PRIMARY KEY,
> foo_name CHAR(80),
> PCTFREE 0
> );
>
> Running dbunload utility gives the following command script:
> CREATE TABLE "DBA"."foo1"
> (
> "id_foo" integer NOT NULL ,
> "foo_name" char(80) NULL ,
> PRIMARY KEY ("id_foo"),
>
> )
>
> Look, PCTFREE parameter is disappeared.
>
>
> Andrei Iliev
>
>
|
|
|
|
|