RE: UDT & SQL query

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

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.