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.







As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.