Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

DBISQL wish list... (from a ASE 15 user)

3 posts in Product Futures Discussion Last posting was on 2006-01-26 16:53:35.0Z
juan avila Posted on 2006-01-25 16:02:54.0Z
From: Juan Avila <javila@mtbase.com>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: DBISQL wish list... (from a ASE 15 user)
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: c3113-139.impsat.com.co
X-Original-NNTP-Posting-Host: c3113-139.impsat.com.co
Message-ID: <43d7a12e$1@forums-1-dub>
Date: 25 Jan 2006 08:02:54 -0800
X-Trace: forums-1-dub 1138204974 200.31.13.139 (25 Jan 2006 08:02:54 -0800)
X-Original-Trace: 25 Jan 2006 08:02:54 -0800, c3113-139.impsat.com.co
Lines: 98
X-Authenticated-User: workspace
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1794
Article PK: 96729

Hi all-

I've been using SQL Advantage for quite a long time, and now I've
switched to the new DBISQL that comes with ASE 15.

DBISQL seems to be a more robust tool than SQL Advantage, but I still
miss some of the old SQL Advantege/isql features.

Here's a list... please go ahead and add more items to it!


1. Support for the old 'go n' (where n is an integer value), which is
available on isql and SQL Advantage, and lets you repeatedly execute a
T-SQL statement 'n' times.

Currently, in DBISQL if you write something like:

insert into my_table values(...)
go 500

and press 'F5' or 'F9', DBISQL displays the message “Incorrect syntax
near 'go'”, and does not execute the statement.

This 'go n' feature is very useful for generating random dummy values,
or other repetitive tasks.


2. Why have two key strokes for executing T-SQL statements? This is
confusing (at least for me...)

DBISQL uses F5 (or the execute button on the toolbar) for 'Execute' and
F9 (No button on toolbar) for 'Execute selection'.

The old SQL Advantage used just one keystroke (Ctrl-E) and button on the
toolbar. If you type Ctrl-E (or press the Execute button) and something
was selected, it executes only the selection; if nothing was selected,
it executed all statements. Isn't this approach more 'intelligent'?

The thing is, since I am (was) a SQL Advantage user, some times I
unconsciously select a statement, press the 'Execute' button, and DBISQL
ends executing all my script!

Or, you could at least add a button to the DBISQL toolbar for 'Execute
selection'...


3. Let me view all ASE configuration options containing some pattern.

I'm not sure this is a ASE or DBISQL issue, but the thing is some DBAs
are (very) used to verify values for ASE configuration options executing
something like this:

sp_configure 'enable'
go

isql/SQL Advantage showed:

Server Message: Number 17411, Severity 16
Server 'SYBASE', Procedure 'sp_configure', Line 209:
Configuration option is not unique.

Parameter Name Default Memory Used Config Value Run
Value Unit Type
-------------- ------- ----------- ------------
--------- ---- ----
enable DTM 0 0 0
0 switch static
enable HA 0 0 0
0 switch static
enable cis 1 0 1
1 switch static
:
:

but DBISQL shows the following error message:
“Could not execute statement. Configuration option is not unique.”

and stops the execution.


4. Last, it would be very useful to add an “Execute to next 'go'” button
and/or keystroke.

Do you remember the (very) old wisql.exe? It was the first graphical
isql client ever for Windows. This tool had the ability to execute
statement from the current cursor position, to the next 'go'. Very
useful for debugging large T-SQL scripts. Wouldn't it be nice to have it
in DBISQL?


Well folks, these are some of my wishes for the new DBISQL that comes
with ASE 15.

I hope you can contribute with more.

Thanks!

Juan Avila


Jeff Tallman Posted on 2006-01-25 18:10:51.0Z
From: Jeff Tallman <tallman@sybase.com>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: DBISQL wish list... (from a ASE 15 user)
References: <43d7a12e$1@forums-1-dub>
In-Reply-To: <43d7a12e$1@forums-1-dub>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-Original-NNTP-Posting-Host: tallman-ibmt30.sybase.com
Message-ID: <43d7bc04$1@forums-2-dub>
X-Original-Trace: 25 Jan 2006 09:57:24 -0800, tallman-ibmt30.sybase.com
Lines: 117
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Jan 2006 09:57:27 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Jan 2006 10:10:51 -0800
X-Trace: forums-1-dub 1138212651 10.22.108.75 (25 Jan 2006 10:10:51 -0800)
X-Original-Trace: 25 Jan 2006 10:10:51 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1795
Article PK: 96727

I have added feature requests for 1, 2 & 4 - #3 was already spotted
(internally) and is being treated as a bug. I can't say about when
these features will get added, but I definitely agree with you on the
usability aspects. There are a couple of things that I really like
about dbISQL that SQL Advantage lacked:

1 - The ability to update a value in the result set and save it back to
the database (really useful for quick data mods).

2 - The ability to connect to things other than ASE - although I have
found sometimes dbISQL won't connect to RS and sometimes it does - but I
think it is more a jConnect issue that dbISQL (just haven't had a chance
to trace it yet with RIBO). SQL Advantage - especially the later
releases really didn't like it when you tried this.

3 - Graphical query plan viewer - especially for procs (gotta love it).

Juan Avila wrote:
> Hi all-
>
> I've been using SQL Advantage for quite a long time, and now I've
> switched to the new DBISQL that comes with ASE 15.
>
> DBISQL seems to be a more robust tool than SQL Advantage, but I still
> miss some of the old SQL Advantege/isql features.
>
> Here's a list... please go ahead and add more items to it!
>
>
> 1. Support for the old 'go n' (where n is an integer value), which is
> available on isql and SQL Advantage, and lets you repeatedly execute a
> T-SQL statement 'n' times.
>
> Currently, in DBISQL if you write something like:
>
> insert into my_table values(...)
> go 500
>
> and press 'F5' or 'F9', DBISQL displays the message “Incorrect syntax
> near 'go'”, and does not execute the statement.
>
> This 'go n' feature is very useful for generating random dummy values,
> or other repetitive tasks.
>
>
> 2. Why have two key strokes for executing T-SQL statements? This is
> confusing (at least for me...)
>
> DBISQL uses F5 (or the execute button on the toolbar) for 'Execute' and
> F9 (No button on toolbar) for 'Execute selection'.
>
> The old SQL Advantage used just one keystroke (Ctrl-E) and button on the
> toolbar. If you type Ctrl-E (or press the Execute button) and something
> was selected, it executes only the selection; if nothing was selected,
> it executed all statements. Isn't this approach more 'intelligent'?
>
> The thing is, since I am (was) a SQL Advantage user, some times I
> unconsciously select a statement, press the 'Execute' button, and DBISQL
> ends executing all my script!
>
> Or, you could at least add a button to the DBISQL toolbar for 'Execute
> selection'...
>
>
> 3. Let me view all ASE configuration options containing some pattern.
>
> I'm not sure this is a ASE or DBISQL issue, but the thing is some DBAs
> are (very) used to verify values for ASE configuration options executing
> something like this:
>
> sp_configure 'enable'
> go
>
> isql/SQL Advantage showed:
>
> Server Message: Number 17411, Severity 16
> Server 'SYBASE', Procedure 'sp_configure', Line 209:
> Configuration option is not unique.
>
> Parameter Name Default Memory Used Config Value Run
> Value Unit Type
> -------------- ------- ----------- ------------
> --------- ---- ----
> enable DTM 0 0 0
> 0 switch static
> enable HA 0 0 0
> 0 switch static
> enable cis 1 0 1
> 1 switch static
> :
> :
>
> but DBISQL shows the following error message:
> “Could not execute statement. Configuration option is not unique.”
>
> and stops the execution.
>
>
> 4. Last, it would be very useful to add an “Execute to next 'go'” button
> and/or keystroke.
>
> Do you remember the (very) old wisql.exe? It was the first graphical
> isql client ever for Windows. This tool had the ability to execute
> statement from the current cursor position, to the next 'go'. Very
> useful for debugging large T-SQL scripts. Wouldn't it be nice to have it
> in DBISQL?
>
>
> Well folks, these are some of my wishes for the new DBISQL that comes
> with ASE 15.
>
> I hope you can contribute with more.
>
> Thanks!
>
> Juan Avila


juan avila Posted on 2006-01-26 16:53:35.0Z
From: Juan Avila <javila@mtbase.com>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: DBISQL wish list... (from a ASE 15 user)
References: <43d7a12e$1@forums-1-dub> <43d7bc04$1@forums-2-dub>
In-Reply-To: <43d7bc04$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: c3113-139.impsat.com.co
Message-ID: <43d8fb63$1@forums-2-dub>
X-Original-Trace: 26 Jan 2006 08:40:03 -0800, c3113-139.impsat.com.co
Lines: 32
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Jan 2006 08:40:04 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Jan 2006 08:53:35 -0800
X-Trace: forums-1-dub 1138294415 10.22.108.75 (26 Jan 2006 08:53:35 -0800)
X-Original-Trace: 26 Jan 2006 08:53:35 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1796
Article PK: 96730

Jeff,

Thank you very much for your interest and answer. I hope DBISQL gets
constantly enhanced, since ASE users have been waiting for a tool like
this for many years!!

I agree SQL Advantage lacks many (many) of the DBISQL features, but
still needs more work.

Thanks again!

Juan

Jeff Tallman wrote on 25/01/2006 01:10 p.m.:
>
> I have added feature requests for 1, 2 & 4 - #3 was already spotted
> (internally) and is being treated as a bug. I can't say about when
> these features will get added, but I definitely agree with you on the
> usability aspects. There are a couple of things that I really like
> about dbISQL that SQL Advantage lacked:
>
> 1 - The ability to update a value in the result set and save it back to
> the database (really useful for quick data mods).
>
> 2 - The ability to connect to things other than ASE - although I have
> found sometimes dbISQL won't connect to RS and sometimes it does - but I
> think it is more a jConnect issue that dbISQL (just haven't had a chance
> to trace it yet with RIBO). SQL Advantage - especially the later
> releases really didn't like it when you tried this.
>
> 3 - Graphical query plan viewer - especially for procs (gotta love it).
>