All executable sql statement must be prepared before they can run.The resutl of preparation is the executable or operational form of the statement.
DB2 data structures:
tables;
table space;
indexes;
index space;
key;
views
databases
An index is an ordered set of pointers to rows of a tables.Each index is
physically stored in its own inde space.
A key is a column or an ordered collection of columns that is identified
in the description of a table,an index,or a referential constraint.
unique key /primary key
foreign key /parent key
A view is a named specification of a result table.
The objects in a relational DB are organized into sets called schemas.
A schema is a collection of named objects. The first part of a schema
is the qualifier.
A schema povides a logical classfication of objects in the DB.The objects
that a schema can contain include tables,indexes,table spaces,distinct types,functions,sp,and triggers.
An object is assigned to a schema when it is created
when a table .....,it is given a qualified two-part name.
the first name is the schema name(of the qualier),which is immplictly or
explictly specified.
the default schema is the authorization ID of the owner of the plan or package.
the second part is the object.
CURRENT SCHEMA AND CURRENT SQLID affect only dynamic sql statement.
static create statement are not affected by either current schema or current sqlid
