|
Home > Archive > SQL Anywhere Feedback > December 2005 > command console for sybase central
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
command console for sybase central
|
|
|
| It would be nice if the wizards & commands provides log output window for
each of the command executed. This will help in learning.
Thanks
vsv
| |
| Reg Domaratzki 2005-12-20, 8:24 pm |
| Once you've connected to a database, go under the "view" menu and select
"Design Details". A new pane opens up in the bottom half of Sybase Central.
The engine tab in the Design Details pane shows the output in the database
engine console log, and the database tab will show all the SQL being
executed against the database in question that modifies the database.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL and click "GO"
"vsv" <nospam@nospam.com> wrote in message news:43a88249@forums
-1-dub...
> It would be nice if the wizards & commands provides log output window for
> each of the command executed. This will help in learning.
> Thanks
> vsv
>
>
| |
|
| When I do dbunload it doesn't logs it.
Thanks
vsv
"Reg Domaratzki" <nospam.please@sympatico.ca> wrote in message
news:43a8b457$1@foru
ms-1-dub...
> Once you've connected to a database, go under the "view" menu and select
> "Design Details". A new pane opens up in the bottom half of Sybase
> Central.
> The engine tab in the Design Details pane shows the output in the database
> engine console log, and the database tab will show all the SQL being
> executed against the database in question that modifies the database.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Certified SQL Anywhere Associate
> Please reply only to the newsgroup
>
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL and click "GO"
>
>
> "vsv" <nospam@nospam.com> wrote in message news:43a88249@forums
-1-dub...
>
>
| |
| Greg Fenton 2005-12-23, 11:23 am |
| vsv wrote:
> When I do dbunload it doesn't logs it.
What do you mean by "do dbunload"?
Do you mean when you select "Unload Database"? If so, then that is not
a command sent to the database engine (which the console shows).
Instead, Sybase Central calls out to the DBUnload() function in the
dbtools library.
For more information:
http://www.ianywhere.com/developer/...n9/00000324.htm
or in the ASA 9.x online docs see:
ASA Programming Guide
The Database Tools Interface
DBTools functions
DBUnload function
Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| Yes that is correct,
It would be a nice to have to see what the command was executed and see as
well in the console.
thanks
vsv
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:43ac339b$1@foru
ms-1-dub...
> vsv wrote:
>
> What do you mean by "do dbunload"?
> Do you mean when you select "Unload Database"? If so, then that is not a
> command sent to the database engine (which the console shows). Instead,
> Sybase Central calls out to the DBUnload() function in the dbtools
> library.
>
> For more information:
>
> http://www.ianywhere.com/developer/...n9/00000324.htm
>
> or in the ASA 9.x online docs see:
> ASA Programming Guide
> The Database Tools Interface
> DBTools functions
> DBUnload function
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Chris Keating(iAnywhere Solutions) 2005-12-23, 8:23 pm |
| But it is an API call? It would not generally be readable without
knowledge of the API.
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
********************
********************
********************
*****************
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com
********************
********************
********************
*****************
| |
| Greg Fenton 2005-12-24, 8:23 pm |
| vsv wrote:
> Yes that is correct,
> It would be a nice to have to see what the command was executed and see as
> well in the console.
As Chris states, "Unload Database" is a call to the DBUnload() function.
There is no "command line" equivalent. If SC was calling out directly
to dbunload.exe, then I'd be in complete agreement with your request.
dbunload.exe is well documented and it should be very straight forward
to determine the exact switches needed in a command line to get the same
behaviour as SC is doing. This is not necessarily the case for the
complex combination of SQL statements that SC may perform in some of its
operations, and this is where the SC console comes into play.
It is an interesting request. I just wonder how the SC team might go
about showing the "options" set in their call to DBUnload() ...
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| the real reason is why requested this is lot of things we would like to do
through command line for batch setup.
The ISQL doesn't provide encrypted config file option.
So there is no way i could put all these into a file including my password.
so, i was trying to find out the equivalents of the command & couldn't find
it.
As well the dbbackup for log files.
It will be nice if they just show the corresponding options in the wizard
itself as text like (use -c with dbunload or like that).
Not necessarily in the command consold output.
Thanks to all for listening.
vsv
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:43adce53$1@foru
ms-2-dub...
> vsv wrote:
>
> As Chris states, "Unload Database" is a call to the DBUnload() function.
> There is no "command line" equivalent. If SC was calling out directly to
> dbunload.exe, then I'd be in complete agreement with your request.
>
> dbunload.exe is well documented and it should be very straight forward to
> determine the exact switches needed in a command line to get the same
> behaviour as SC is doing. This is not necessarily the case for the
> complex combination of SQL statements that SC may perform in some of its
> operations, and this is where the SC console comes into play.
>
> It is an interesting request. I just wonder how the SC team might go
> about showing the "options" set in their call to DBUnload() ...
>
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
|
|
|
|
|