Re: UDT & SQL query

[fabio.gloria@xxxxxxxxxxxxxx]

Hi Sudha,
what about to concatenate all the values you want to return in a big char
parameter (say 2000 chars) using a field separator ?

Remember also that right from V5R1 you can generate *SQL UDT

Fabio



                                                                                
                                                          
                      SRamanujan@sungardfu                                      
                                                          
                      tures.com                   To:       
midrange-l@xxxxxxxxxxxx                                                       
                      Sent by:                    cc:                           
                                                          
                      midrange-l-bounces@m        Subject:  UDT & SQL query     
                                                          
                      idrange.com                                               
                                                          
                                                                                
                                                          
                                                                                
                                                          
                      18/03/2004 17.50                                          
                                                          
                      Please respond to                                         
                                                          
                      Midrange Systems                                          
                                                          
                      Technical Discussion                                      
                                                          
                                                                                
                                                          
                                                                                
                                                          




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.