[Squirrel-sql-users] RE: newbie question about stored procedures

Hi Peter,

Your email didn't go through to the list because of the size of the
attachments. Next time just zip up any attachments and it should go through
automatically.

If the stored procedure returns its data through a result set then SQuirreL
should display it. I don't currently have access to Sybase but with
Microsoft SQL Server "exec sp_tables" for example returns results. Could you
test one of the standard system stored procedures to see if they return a
result set in SQuirreL?

One problem in SQuirreL 1.1 that has been fixed in CVS and will be available
in the soon to be released 1.2 beta concerns multiple result sets. If your
stored procedure returns multiple result sets only the first will be
displayed, subsuquent ones will be ignored.

> Also BTW,  I installed squirrel (and java) on a windows network drive (I
> know this sounds bad) so that my co-workers could use it.  Is there a way
> for us to share a "group" alias file,
> while each keeping a copy of our own alias file?

Not currently. If you'd like it just add an entry to the wish list at
SourceForge.

Col

-----Original Message-----
From: Kleinmann, Peter G [mailto:pk...@le...]
Sent: Friday, 20 June 2003 12:36
To: Colin Bell
Subject: newbie question about stored procedures




I just installed squirrel-sql and I think its really cool, but, I can't seem
to get output from stored procedures.
On a sybase enterprise server,  I can run the following:

exec GetData
@AliasOwner='gmdpublic',@AliasName='CLOSINGVOL',@StartDate='20020621',@ThruD
ate='20020621'

via isql, I get
----------------------------------------------------------------------------
---------------------------------------------------
 ConceptID   QuoteDate                  DataPoint            DataPointFlag
         AliasTag
 ----------- -------------------------- -------------------- -------------
        ----------------------------------------------------------------
      273322        Jun 21 2002 12:00AM             2.449991 V
         CVUSDV01_M

      //rows deleted

      292913        Jun 21 2002 12:00AM             5.817167 V
         CVUSDV30_M

(307 rows affected, return status = 0) 


but via squirrel, I get
----------------------------------------------------------------------------
---------------------------------------------------
1 Rows Updated
Query 1 elapsed time (seconds) - Total: 0.062, SQL query: 0.062, Building
output: 0


I can execute standard sql commands without compilcations.


In case this helps, I've attached an application dump and a session dump.
I would have attached the log as well, but only recent messages where about 
drives for db's we don't have.

Your help would be very much appreciated.

 <<squirrel-session>>  <<squirrel>> 


thanks in advance,

Peter


BTW, pardon me if this is too sybase specific, but I found a great applet
for converting 
sybase interface file data into hosts and ports, which can then be used to
construct the 
url's for sybase connection strings.  Its at:
http://www.outlands.demon.co.uk/utilities/tli2ip.html
<http://www.outlands.demon.co.uk/utilities/tli2ip.html> 


Also BTW,  I installed squirrel (and java) on a windows network drive (I
know this sounds bad)
so that my co-workers could use it.  Is there a way for us to share a
"group" alias file,
while each keeping a copy of our own alias file?

This is a nice piece of work.







----------------------------------------------------------------------------
--
This message is intended only for the personal and confidential use of the
designated recipient(s) named above.  If you are not the intended recipient
of
this message you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited.  This
communication is for information purposes only and should not be regarded as
an offer to sell or as a solicitation of an offer to buy any financial
product, an official confirmation of any transaction, or as an official
statement of Lehman Brothers.  Email transmission cannot be guaranteed to be
secure or error-free.  Therefore, we do not represent that this information
is
complete or accurate and it should not be relied upon as such.  All
information is subject to change without notice.