× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2012

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

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 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.