DBPowerSuite 7.9 List of Programs

#	Category	Number of Programs
1	ODBC Programs	12
2	Generic Database Programs	23
3	Sybase Programs	76
4	Sybase Replication Server Programs	9
5	Sybase Open Server Programs	1
6	Utility Programs	44

ODBC Programs

#	Program	Description
1	psOLoader	Uploads a field-delimited text file to an ODBC table
2	psOCopyTableData	Writes scripts to move data from one ODBC data source to another
3	psODropIndices	Writes SQL script to drop indices
4	psOHelp	Lists only the ODBC and utility programs
5	psOListIndices	Lists the index names at an ODBC data source
6	psOListProcedures	Lists the procedure and function names at an ODBC data source
7	psOListTables	Lists the table names at an ODBC data source
8	psOListViews	Lists the view names at an ODBC data source
9	psOSQL	Executes SQL by file or interactive session on a data source
10	psOPing	Tests if you can connect to an ODBC data source
11	psOTestReconnects	Tests the ODBC drivers to see if they can reconnect to the DSN
12	psOTestThreads	Tests the ODBC drivers and client libraries for thread-safety

Generic Database Programs

#	Program	Description
13	psGAddCheckConstraints	Writes a SQL script to add check constraints
14	psGAddRIConstraints	Writes a SQL script to add referential integrity constraints
15	psGChangeTablespaces	Writes a SQL script that changes tablespaces on tables or indices
16	psGCheckRIConstraints	Writes a SQL script to check referential integrity constraints
17	psGCheckRules	Writes a SQL script to check check constraints and rules
18	psGCopyTableData	Writes scripts to move data from one ODBC data source to another (req. Sybase)
19	psGCountRows	Writes a SQL script to count the rows in specific tables
20	psGDeleteRIViolators	Writes a SQL script to delete rows violating referential integrity constraints
21	psGDeleteRuleViolators	Writes a SQL script to delete rows violating check constraints and rules
22	psGDropCheckConstraints	Writes a SQL script to drop check constraints
23	psGDropRIConstraints	Writes a SQL script to drop RI constraints
24	psGDropProcedures	Writes a SQL script to drop stored procedures or functions
25	psGDropTables	Writes a SQL script to drop tables
26	psGDropViews	Writes a SQL script to drop views
27	psGenerateCCDatatypes	Write C++ code for DBDatatype::dtLoadDefinitions
28	psGReindex	Writes a SQL script which rebuilds indices.
29	psGSegmentSQL	Adds segment/tablespaces to Power Designer SQL scripts
30	psGSetOracleTableLogging	Turns archive logging on/off for Oracle tables
31	psGSetOracleTableParallel	Turns parallelism on/off for Oracle tables
32	psGTruncateTables	Writes a SQL script to truncate tables
33	psGUpdateStatistics	Writes a SQL script to update statistics for tables
34	psGWriteSQL	Writes a SQL script using a list of objects and a printf() format
35	psIsReservedWord	Tells you if your text is a database reserved word

Sybase Programs

#	Program	Description
36	psBCP	Bulk copies a file into a table
37	psBcpIntoTable	Writes a ksh script which drops indexes, runs bcp, readds indexes
38	psBindDefaults	Writes a ksh script which binds columns to created defaults
39	psBindRules	Writes a ksh script which binds columns to created rules
40	psCheckBulkCopyFile	Checks whether an ASCII bulk copy file can be loaded
41	psCheckDB	Runs dbcc checkalloc(db, fix) on databases
42	psCheckpoint	Performs a checkpoint in every write-enabled database
43	psCheckRIConstraints	Writes a ksh script which checks tables for referential integrity
44	psCheckRules	Writes a ksh script which checks whether tables abide by their rules
45	psCopyDefaults	Writes a ksh script which copies defaults from 1 db to another
46	psCopyIndices	Writes a ksh script which copies tables' indices
47	psCopyKeys	Writes a ksh script which copies sp_primarykeys and sp_foreignkeys
48	psCopyProcedures	Writes a ksh script which copies procs from 1 db to another
49	psCopyRIConstraints	Writes a ksh script which copies ref. integrity constraints
50	psCopyRules	Writes a ksh script which copies rules from 1 db to another
51	psCopySchema	Writes a ksh script which copies a schema from 1 db to another
52	psCopyTableData	Writes a ksh script which copies table data from 1 db to another
53	psCopyTables	Writes a ksh script which copies table column definitions
54	psCopyTriggers	Writes a ksh script which copies triggers from one schema to another
55	psCopyUserTypes	Writes a ksh script which copies user-defined datatypes
56	psCopyViewKeys	Writes a ksh script which copies sp_primarykeys and sp_foreignkeys on views.
57	psCopyViews	Writes a ksh script which copies views from one schema to another
58	psDropDefaults	Writes a ksh script which drops defaults
59	psDropDevices	Writes a ksh script which drops devices
60	psDropIndices	Writes a ksh script which drops tables' indices
61	psDropKeys	Writes a ksh script which drops sp_primarykeys and sp_foreignkeys
62	psDropProcedures	Writes a ksh script which drops stored procedures
63	psDropRIConstraints	Writes a ksh script which drops ref. integrity constraints
64	psDropRules	Writes a ksh script which drops rules
65	psDropSegments	Writes a ksh script which drops segments
66	psDropTables	Writes a ksh script which drops tables
67	psDropTriggers	Writes a ksh script which drops triggers
68	psDropUserTypes	Writes a ksh script which drops user-defined datatypes
69	psDropViewKeys	Writes a ksh script which drops sp_primarykeys and sp_foreignkeys on views
70	psDropViews	Writes a ksh script which drops views
71	psDumpDatabase	Dumps a database
72	psDumpServer	Wrties a ksh script which dumps all databases of a Sybase server
73	psDumpTransactionLog	Dumps a database's transaction log
74	psEstimateSpace	Estimates the sizes of tables & indexes, grouped by segment
75	psEstimateSpaceFile	Generates a list of tables for input to psEstimateSpace
76	psFindProcedure	Finds a stored procedure amongst all databases in an ASE server.
77	psFindTable	Finds a table amongst all databases in an ASE server.
78	psFindView	Finds a view amongst all databases in an ASE server.
79	psGenerateCCDefines	Generates a C++ header #-defining the max lengths of columns
80	psGenerateDumpName	Generates a file name for a DB or transaction log dump
81	psGenerateRIMap	Generates a list of tables and outgoing RI constraints
82	psGenerateRITriggers	Generates ref. integrity triggers based on sp_foreignkeys
83	psGenerateSegmentMap	Generates a list of tables and their segments
84	psGenerateTable	Generates C++ classes which invoke generated stored procedures
85	psGetSegment	Displays a table's segment name
86	psKillProcesses	Kills processes on a Sybase ASE server
87	psListDefaults	Lists all defaults created with 'create default'
88	psListDevices	Lists all ASE server physical devices & the databases living on them
89	psListInterfaces	Lists all the servers in the interfaces file
90	psListProcedures	Lists all stored procedures
91	psListProcesses	Lists CPU, I/O, and memory usage for ASE spids in realtime
92	psListRules	Lists all rules created with 'create rule'
93	psListSegments	Lists all segments' table & index space allocations
94	psListTables	Lists all tables w/ indices, constraints, etc.
95	psListTablesForWeb	Generates a HTML page for each table definition
96	psListTriggers	Lists all triggers
97	psListUsers	Lists all users in a database
98	psListUserTypes	Lists all user-defined datatypes
99	psListViews	Lists all views
100	psLoadDatabase	Loads a database
101	psLoadTransactionLog	Loads a database's transaction log
102	psPingServer	Checks if a Sybase server is up
103	psSetPermissions	Writes a ksh script which sets permissions on objects and users
104	psSQL	Executes SQL or other commands on a Sybase ASE or Open server
105	psTestThreads	A test multithreaded Sybase Open Client program
106	psTranslateSchema	Translates a Sybase schema into Oracle scripts
107	psTruncateTables	Writes a ksh script which truncates tables
108	psUnbindDefaults	Writes a ksh script which unbinds columns from created defaults
109	psUnbindRules	Writes a ksh script which unbinds columns from created rules
110	psUpdateServer	Writes a ksh script which updates statistics for all databases
111	psUpdateStatistics	Writes a ksh script which updates statistics in a single database

Sybase Replication Server Programs

#	Program	Description
112	psCheckRepDefs	Checks & waits for rep defs to exist or drop
113	psCheckSubscriptions	Checks & waits for subscriptions to attain a specified state
114	psDropRepDefs	Writes a ksh script which drops replication definitions
115	psDropSubscriptions	Writes a ksh script which drops subscriptions
116	psGenerateRepDefs	Generates replication definitions
117	psGenerateSubscriptions	Generates subscriptions from rep defs
118	psListRepDefs	Lists the replication definitions in a RSSD
119	psListSubscriptions	Lists the subscriptions in a RSSD
120	psMarkTablesForRep	Writes a ksh script which turns replication on or off for tables

Sybase Open Server Programs

#	Program	Description
121	psOpenServer	An open server which has RPCs to run UNIX commands and e-mail

Utility Programs

#	Program	Description
122	psArchiveFile	Appends '.old' to a file name if the file is too big
123	psCase	Converts a phrase to upper or lower case
124	psCompute	Evaluates a mathematical expression
125	psCopyFile	Copies a file
126	psControlCharacters	Shows the invisible control characters in a text file
127	psConvertFileToLowerCase	Converts a text file to lower case
128	psConvertFileToUpperCase	Converts a text file to upper case
129	psConvertToWebText	Converts a text file to HTML
130	psDecode	Decodes a base-64 text string into a bit pattern
131	psDeleteFiles	Deletes certain files recursively under a directory
132	psDemangle	Demangles a C++ symbol
133	psDocumentAPI	Generates web pages of help for PS APIs
134	psDocumentPrograms	Generates web pages of help for PS programs
135	psDoesExpressionMatch	Shows whether or not text matches a database LIKE expression
136	psDoesProcessExist	Displays whether a process exists or not
137	psGetComputerName	Gets the computer name given an IP address or network address
138	psGetIPAddress	Gets the network and IP address given a computer name
139	psHash	Displays signed and unsigned hash values for text
140	psHelp	Displays a list of PS programs and PS environment variables
141	psListFiles	Lists the unusual attributes of files in a directory
142	psListParameters	Lists the parameters in a parameters database
143	psLoadMessages	Writes a messages catalog file given a text file
144	psLoadParameters	Writes a parameters database given a text file
145	psMakeMessagesFunction	Makes a C++ function which gets PS messages from memory
146	psPortCode	Copy a directory structure to another while replacing strings
147	psRemoveWhiteSpaces	Removes leading and trailing white spaces from records in a text file
148	psRenameFile	Renames a file
149	psReplaceStrings	Replaces old strings with new strings in a text file
150	psRotateLog	Receives data on standard input and writes it to a rotating log file
151	psShowConfigValue	Looks up the value for a section and key in a Windows-style .ini file
152	psShowDirectorySizes	Displays the total sizes of directories
153	psShowDiskPerformance	Exercises disk reads and writes and displays performance statistics
154	psShowErrno	Displays the meaning of an operating system 'errno' code
155	psShowLocale	Displays your environment's international locale
156	psShowMessage	Displays the text associated with a DBPowerSuite return code
157	psShowParameter	Displays the value of a DBPowerSuite parameter
158	psShowPerformance	Exercises CPU and memory and displays performance statistics
159	psShowTime	Converts system clock times to and from Gregorian times
160	psSleep	Sleeps for N seconds
161	psTestGetIPAddresses	Tests the ability to get network addresses from computer names
162	psTestLibrary	Tests whether a dynamic library will link without other libraries
163	psTranslateIP	Translates IP addresses to and from network addresses
164	psUPing	Tests if remote TCP/IP servers are up and listening for connections
165	psWhatVersion	Displays the DBPowerSuite version number