MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: Another SQL question (yes, I know, I'm getting annoying; at least this is a different project)



fixed

REXX has functions that parse stuff so well, it could maybe be a part of a UDF - need to have a CL wrapper, probably.

This would be a tokenizing function, and that is built into REXX - result goes into an array, as I recall.

Just a thought!
Vern

On 10/5/2012 1:11 PM, Luis Rodriguez wrote:
James,

(annoying? No. A honest quest for knowledge is always a good thing :-) )

Not an easy one..(at least for me). Maybe you could write an UDF (User
defined function) that parses and recreates the string in a sorted order.
Also, beginning V5R4 there are several recursive and ranking functions in
SQL, that could be of help. Unfortunately, in our shop our 520 was stopped
at V5R3 :-(

Rehards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact