SqlDbx Forum

SqlDbx

You are not logged in.

#1 Re: Suggestions and Feedback » Multiple queries with parameters » 2009-12-16 05:52:45

Monk

I tested this feature for Oracle and see that it is not working properly. It is working for Sybase without problem..

#2 Re: Suggestions and Feedback » Export multiple tables to one XML file and parse for import » 2009-12-16 05:06:59

Monk

Current export/import functionality is broken for Sybase I think.  I didn't manage to import an exported file with sqldbx. You should make some improvements for applying export/import in a consistent way.

#3 Suggestions and Feedback » locking and making read only selected SQL blocks » 2009-12-16 04:40:51

Monk
Replies: 0

locking selected blocks and avoid executing these selected blocks while pressed F5 or CTRL+e  might be a usefull feature for Sqldbx.

Also Read only feature applies for whole document. Maybe it could be more useffull if it is applied to only selected blocks.

#4 Re: Suggestions and Feedback » log all session input and output » 2009-12-16 04:18:30

Monk

applying strict row limit like 100 rows while logging output to a file may solve the confusion.

#5 Re: Suggestions and Feedback » Show and define proxy tables for SYBASE » 2009-12-16 03:38:49

Monk

No comments sad
I’m still thinking that showing and defining remote servers and proxy tables is a reasonable request. Also it is possible to apply this feature for IQ. In Sqldbx, it is impossible to identify proxy tables between usual user tables and find out which proxy table bind to which remote table.

Needed information can be found under sysattributes system table.

#6 Suggestions and Feedback » Find doesn't work under messages tab » 2009-12-11 06:20:58

Monk
Replies: 1

I tried to search for an error code under messages tab from huge number of errors. I saw that find option doesn't work under messages tab.

#7 Sybase ASE » Bug on generate scripts. » 2009-12-11 04:32:43

Monk
Replies: 1

When I try to genearete table scripts without index and constraints, sqldbx generates scripts with index and constarints everytime.  I tested it on Sybase ASE 15.0.3 ESD#1

Also is it possible to generate scripts only for indexes or constraints in a database.

#8 Suggestions and Feedback » Show sql history crashes » 2009-12-10 06:48:23

Monk
Replies: 1

When I click on show Sql history, Sqldbx crashes. I tested it at the Personel edition v.3.41.

#9 Suggestions and Feedback » show and define Remote servers for SYBASE » 2009-11-29 06:23:03

Monk
Replies: 0

ability of defining and showing defined remote servers will be a nice feature for SYBASE.

#10 Suggestions and Feedback » Show and define proxy tables for SYBASE » 2009-11-29 06:16:21

Monk
Replies: 2

Proxy tables create statements are not shown correctly. they should be as
'create existing table <table_name>(column list) at <REMOTE_SERVER>.<remote_table_name>'
if any proxy table defined under a database they should be shown under a seperate tab other than usual table tab.

#11 Suggestions and Feedback » Show performance Metrics according to MDA tables for Sybase » 2009-11-25 04:13:26

Monk
Replies: 1

Showing sistem performance for Sybase according to MDA tabes will be a nice feature . For example; showing cache hit ratios. network & disk I/O perfromance, executed sql statements with their wait time and wait events... May be this feature can be places at Server explorer.

#12 Suggestions and Feedback » log all session input and output » 2009-09-29 06:04:54

Monk
Replies: 2

is it possible to log session input and output to a text file?

#13 Re: Sybase ASE » Bug on table row limit » 2009-06-30 01:55:33

Monk

this issue is still broken

#14 Re: Suggestions and Feedback » Export multiple tables to one XML file and parse for import » 2009-06-19 06:29:31

Monk

is there any plans for this request. We would really like to see this feature in sqldbx.

#15 Sybase ASE » Bug on result tab while generating update script for views » 2009-06-16 05:15:03

Monk
Replies: 1

sqldbx can't generate an update script for a record from a view's output. This issue is only valid for views and I tested it on ASE 15.0.2

#16 Sybase ASE » Bug on table row limit » 2009-05-27 08:22:37

Monk
Replies: 5

I limit the returned row number with 100 and queried a table containing more than 1 million rows. It first read the whole table and returned 100 rows and query time took as long as the select result time without using the row limit. I tested it on Sybase ASE 15.0.2.

#17 Re: Suggestions and Feedback » New feature request for Sybase and Microsoft » 2009-05-08 02:03:58

Monk

You added bulk copy support for Sybase and MSSQL but it comes disabled. How can I use it?

#18 Re: Sybase ASE » Drop multiple tables doesn't work well » 2009-04-22 04:32:46

Monk

Same case also happens while removing multiple favorite objects. It can't remove them at one time.

#19 Re: Suggestions and Feedback » Export multiple tables to one XML file and parse for import » 2009-02-18 06:47:35

Monk

Yes, it is a good idea if you are importing at the same platform.

For cross platforms ; for example; if I want to import a table from Sybase to Oracle data types will not match. Is it possible to handle this?

I think making data types optinal while export/import will be more convinent.

#20 Suggestions and Feedback » Export multiple tables to one XML file and parse for import » 2009-02-17 10:52:13

Monk
Replies: 6

Exporting multiple tables to a single XML file will be very handy and  able to parse and import multiple tables from that XML file to a database will be a very nice feature for sqldbx.

XML output should be;

<MOTree>
< MO TableName="Table1" >
     <attr name="column1">value</attr>
     <attr name="column2">value</attr>
</MO>

< MO TableName="Table2" >
     <attr name="column1">value</attr>
     <attr name="column2">value</attr>
          .
          .
     <attr name="columN">value</attr>
</MO>   
</MOTree>

Than, maybe this feature could be supported by command line by sqldbx.

#21 Re: Suggestions and Feedback » New feature request for Sybase and Microsoft » 2009-02-16 06:12:20

Monk

I agree, it will be very usefull. Basic Bcp parameteres for sybase and mssql are in common.  I think it will be much more easier to implement sybase BCP than mssql's bcp.

For sybase, bcp.exe is located under %sybase%/%sybase_OCS%/bin. When connected to a sybase database through sqldbx, it can use this bcp.exe

There is no envoirenment variable defined for mssql side. To locate the exact location of bcp, maybe the best way is to let the user to locate the location of bcp.exe for microsoft.

#22 Re: Sybase ASE » Drop multiple tables doesn't work well » 2009-02-13 05:13:48

Monk

I am still having problems while dropping multiple tables. Did you have the chance to look at this problem.

#23 Re: Sybase ASE » Database explorer error » 2009-02-13 05:08:37

Monk

I am having this issue at ASE 15.0.2 ESD 6.

Error text: Changed database context to '<Database Name>'. This operation not yet supported. Index =16

#24 Sybase ASE » Database explorer error » 2009-02-12 05:02:52

Monk
Replies: 3

When I try to list functions for a specific database from database explorer. Sqldbx gives error.

#25 Re: Sybase ASE » Export Import » 2009-02-12 04:37:15

Monk

In addition to this post: Also the same issue happens while trying to export and import XML's.

Board footer

Powered by FluxBB