Product Version       = NetBeans IDE Dev (Build
200409071800)
  Operating System      = Linux version
2.4.22-1.2115.nptl running on i386
  Java; VM; Vendor      = 1.5.0-rc; Java
HotSpot(TM) Client VM 1.5.0-rc-b63; Sun
Microsystems Inc.
  Java Home             = /usr/local/java/jdk1.5.0/jre
  System Locale; Encod. = cs_CZ (nb); ISO-8859-2
  Home Dir; Current Dir = /usr/local/home/delphym;
/usr/local/forte/forte3/NBdev-last/netbeans/bin
  IDE Install; User Dir =
/usr/local/home/delphym/NBdev-last/platform4;
/usr/local/home/delphym/.netbeans/dev

DB2 8.1 on W2K,
jdbc driver "db2java.zip" shipped with that DB.
Drive Class: COM.ibm.db2.jdbc.net.DB2Driver
-------------------------------------------------------------------------------

I've created Table with settings a primary key and
index on some column using IDE-DB GUI (not SQL
command). I had turned on debugging, so it printed
out the SQL commands:


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
create table "DB2ADMIN"."Title"
(
	"ID" SMALLINT not null,
	"MSET" SMALLINT not null,
	"TITLE" VARCHAR(50),
	"TYPE" SMALLINT,
	"USEDMEDIA" SMALLINT,
	"DESCRIPTION" VARCHAR(500),
	primary key (ID, MSET)
)
 
create  index "Title_TITLE_idx" on "DB2ADMIN"."Title"
(
	"TITLE"
)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Table was succesfuly created with one primary key
and with one index.
So far good.


Then I grabed table structure and save it on the
disk. (this "Title.grab" file I'm attaching)


Then I wanted to recreate the table.
In JFileCHooser I selected Title.grab file and
open it.
From the first sign the SQL commands in the table
script little differs from  the previously
executed which successfuly created table + PK + index

I change Name: from Title to zzzzTitle and
executed it.
But command's execution failed.
Here is the SQL command reconstructed from the
GRAB file:

create table "DB2ADMIN"."zzzzTitle"
(
	"ID" SMALLINT not null primary key,
	"MSET" SMALLINT not null primary key,
	"TITLE" VARCHAR(50),
	"TYPE" SMALLINT,
	"USEDMEDIA" SMALLINT,
	"DESCRIPTION" VARCHAR(500)
)



primary keys are diffined just after column names.
I don't know SQL specification nor even DB2
differencies from that, but I guess, that reusing
GRAB structure on the same DB type and version
should work because of this GRAB file is not
simply stored SQL command in TXT format, but it
contains some binary data which I guess are (or
should be)related to the type of DB on which it
was created.