Map the Sybase Central Wizard's actions to their according utlility command lines

[Volker Barth]

Hi all,

this is a follow-up from the thread "Reloading tables with autoincrement
columns" on the general NG.

I would like either of the following:
a) A documentation that maps the Sybase Central's Wizard's action to the
according tool command line (or to the DbTool structure's contents)
or
b) The possibiliy to capture the particular's Wizard's action in a command
log file - say, if I use the Unload Wizard to make a reload.sql-based
unload, an additional log file would be generated and would contain
something like
"%SQLANY11%\bin32\DBUNLOAD -c ... -ii -r c:\MyPath\reload.sql
c:\MyUnloadDir"
(possibly leaving out the default options).

Reasoning:
For use in production (especially in a replication/synchronization based
setup), I prefer scripts and command batches.
But for ad-hoc testing or learning about new features (or about senseful
default behaviour), the Wizards are quite useful - and were even more
useful when one could "extract" their action in a command line for later
use.

It would it also make easier to find out whether the Wizards make use of the
more advanced options like "DBUNLOAD -l" - and if they do not (as in this
case), it would be easy to add this to an otherwise unchanged command.

IMHO this would dovetail the advantages of both "easy GUI" and "advanced
command line" usage:)

Regards
Volker

[Rich Jones]

This feature has already been added for the next major version of SQL
Anywhere.

With this new feature, most wizards that either create a database object
(such as CREATE USER) or run a database utility (such as CREATE DATABASE or
dbunload) now include a new page at the end of the wizard. This page
displays the SQL or command that is executed if the Finish button is
clicked. Clicking Finish executes the SQL or command as it did in previously
versions. Alternatively, you can copy the SQL or command to the clipboard,
click Cancel to exit the wizard, and then execute the SQL later via
Interactive SQL, or run the command from a command prompt.

This feature allows you to use the wizards to generate SQL scripts without
actually modifying the database.

Rich Jones
ianywhere Engineering

"Volker Barth" <No_VBarth@Spam_GLOBAL-FINANZ.de> wrote in message
news:4a111895@forums-1-dub...

[Volker Barth]

Rich,

good news - that's even more than I suggested :)
Particularly the option to "generate" the commands without having to execute
them in the GUI seems smart.

Regards

Volker Looking Forward

"Rich Jones" <ri...@sybase.com> wrote in news:4a1af143@forums-1-dub...