RE: UDT & SQL query

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

Thanks Fabio.  Are you talking about the SQL scalar functions in SQL?  I
want to get the fields from the file that have been defined as char and
contain 8 bit data.  The only way currently is to read these through
rpgle and transform the values to another field.  This is the reason I
am trying the UDT, also I have flat files with packed data.  I need to
use the sqlrpgle.  I am not sure what I can do there with *sql udt.  Any
help will be appreciated.
Thanks again,
Sudha

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


-----Original Message-----
From: fabio.gloria@xxxxxxxxxxxxxx [mailto:fabio.gloria@xxxxxxxxxxxxxx] 
Sent: Thursday, March 18, 2004 11:12 AM
To: Midrange Systems Technical Discussion
Subject: Re: UDT & SQL query


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.






_______________________________________________
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.