"compute" data in TDS

Thompson, Bill D (London) ThompBil at exchange.uk.ml.com
Tue Sep 24 11:56:37 EDT 2002


Freddy,

Its the data returned by a server when a "compute" clause is present on a
query.

You may not know (as I didn't ) that you can specify a compute clause like
this :

USE pubs

SELECT type, price, advance
FROM titles
ORDER BY type
COMPUTE SUM(price), SUM(advance) BY type

On the wire the server sends back some extra "results" messages , describing
the computed data, and extra "row" messages, containing the computed data.
We currently don't handle this data very well.


Bill


> -----Original Message-----
> From:	ZIGLIO Frediano [SMTP:Frediano.Ziglio at vodafoneomnitel.it]
> Sent:	Tuesday, September 24, 2002 8:55 AM
> To:	TDS Development Group
> Subject:	[freetds] RE: "compute" data in TDS
> 
> > 
> > Hi all,
> > 
> > I've pretty much got the compute data wire protocol 
> > implemented, at least
> > for TDS 7 & 8. I'm also pretty close to finishing the dblib 
> > functions that
> > go along with it. I think I've worked out what the slight 
> > differences are
> > with TDS 5, but I'd like to confirm.
> > 
> 
> Stupid question: what's compute data ?
> 
> freddy77
> 
> =================================
> "STRICTLY PERSONAL AND CONFIDENTIAL
> 
> This message may contain confidential and proprietary material for the
> sole
> use of the intended recipient. Any review or distribution by others is
> strictly prohibited. If you are not the intended recipient please contact
> the sender and delete all copies.
> The contents of this message that do not relate to the official business
> of
> our company shall be understood as neither given nor endorsed by it."
> 
> =================================
> 
> ---
> You are currently subscribed to freetds as: [thompbil at exchange.uk.ml.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')




More information about the FreeTDS mailing list