psGenerateSegmentMap

Description

     This program makes a table to segment map for input into programs
psCopyIndices or psCopyTables.

 

Syntax

psGenerateSegmentMap -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-Xtable_segment -xnon_clustered_index_segment -iimage_segment
-Foutput_segment_map -Ooptions

 

Arguments

-S

Source Sybase Server Name

-U

Source Sybase User Name

-P

Source Sybase User Password

-D

Source Sybase Database

-W

Use tables belonging to 'owner' only

-N

Use tables having pattern 'name'

-X

Target table/clustered index segment

-x

Target non-clustered index segment

-i

Image/Text segment

-F

Name of output segment map file for psCopyTables or psCopyIndices [standard output]

-O

Options

 

Options

c

Generate the list in order that the tables were created

r

Generate the list in reverse order that the tables were created

 

Environment Variables Behind the Scenes

DSQUERY

When -S is not specified

SYB_USER

When -U is not specified

SYB_PASS

When -P is not specified

SYB_DATABASE

When -D is not specified

PS_SYSMSG_FILE

Name of the tool's messages file

 

Go to DBPowerSuite 7.9 List of Programs.


Updated: Thu Jun 18 21:12:26 2009