export company, contact, state, status from customers,
orders where customers.customer_no = orders.customer_no and
status='cncl' to cncl.ost with ost
attach /users/test/cncl.ost as CANCELED
select company, contact from customers where state='CO'
detach ost canceled
Syntax
DETACH OST table [ON [INSTANCE] instance][WITH
options]
DETACH OST
Required
table
Required - Table name of the OST to be detached, as it was
named when the OST was attached.
[ON [INSTANCE] instance]
Optional - Specify which instance the OST was assigned to.
Default is the current instance. The "INSTANCE"
keyword is optional.
[WITH options]
Optional - Specify options to be used for this command.
top
OdxSQL Example
This example creates an OST that contains customers who have
canceled their order and names the OST 'canceled'. The OST
is attached on the default current instance, a select statement
is run, then the OST is detached.
>export company, contact, state, status from
customers, orders where customers.customer_no=orders.customer_no
and status='cncl' to cncl.ost with ost
79 rows exported to cncl.ost
>attach /users/test/cncl.ost as CANCELED
>select company, contact from customers where
state='CO'
...
22 rows returned
>detach ost canceled
table CANCELED detached
top
|