RE: UDT & SQL query

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

You must be doing a "SELECT DISTINCT" for it to insist on processing all
rows.  Sorry, but certain statements will always require the entire table to
be processed before you can fetch the results.   

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: SRamanujan@xxxxxxxxxxxxxxxxxx
[mailto:SRamanujan@xxxxxxxxxxxxxxxxxx]
Sent: Thursday, March 18, 2004 12:37 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: UDT & SQL query


Rob, I can fetch a few records but the select still selects all rows.
If only I could avoid this traffic for each request, it will truly be
nice.
Thanks,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax


-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] 
Sent: Thursday, March 18, 2004 11:55 AM
To: Midrange Systems Technical Discussion
Subject: Re: UDT & SQL query

As far as your second paragraph, does the
FETCH FIRST... ROWS
clause in your select statement ring a bell?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





<SRamanujan@xxxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/18/2004 11:50 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
UDT & SQL query






Hi All,

I am trying to use a UDT on a file to return more meaningful fields.  I
wanted to know if there are any restrictions to the number of
parameters/fields that can be returned.  I have some 100 odd fields and
will increase after I am done with expanding them. I find my program
already complaining at the number of returns. I don't want to write
separate UDT for different set of data from the same file. Is there a
solution for this?  A work around maybe?

 

This was proably already discussed earleir, but when I sql a file, I get
all the rows returned and that could be anywhere upto millions.  I know
I can monitor my fetch but is there any way I could reduce the traffic
by indicating how many number of records I want the sql to return as
well?

 

Thanks in advance,

Sudha

 

Sudha Ramanujan

SunGard Futures Systems

sramanujan@xxxxxxxxxxxxxxxxxx <mailto:sramanujan@xxxxxxxxxxxxxxxxxx> 

(312) 577 6179

(312) 577 6101 - Fax

 

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.