psODropIndices

Description

     This program writes a SQL script, which when run using psOSQL,
drops indices for tables.

Syntax

psODropIndices -Sdsn -Vserver -Uusername -Ppassword
-Dcatalog -Wowner -Ntable
-Eexc_table_name_pattern -Ilist_of_tables_file
-Foutput_script -Ooptions

-S

ODBC Data Source

-V

ODBC Server Name

-U

ODBC User Name

-P

ODBC User's Password

-A

ODBC Other Attributes

-D

ODBC Catalog (Database)

-W

Table belongs to this 'schema'

-N

Table having pattern 'name'

-E

Exclude tables with pattern

-I

Input file containing list of tables names to copy

-F

Output file [standard output]

-O

Options

m

Use Data Direct ODBC drivers

s

Include schema name with table.index names

ODBC_DSN

When -S is not specified.

ODBC_SERVER

When -V is not specified.

ODBC_USER

When -U is not specified.

ODBC_PASS

When -P is not specified.

ODBC_ATTR

When -A is not specified.

PS_SYSMSG_FILE

Name of the tool's messages file.

PS_SYSPARAM_FILE

Name of the system parameter file