MQSeries.net :: View topic - Sort letters in word in alphabetical order

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Sort letters in word in alphabetical order

Sort letters in word in alphabetical order

« View previous topic :: View next topic »

Author

Message

akidase

Posted: Mon Oct 17, 2011 9:06 pm Post subject: Sort letters in word in alphabetical order

Centurion

Joined: 10 Jan 2011
Posts: 124

Any function for it ?

akidase

Posted: Mon Oct 17, 2011 11:21 pm Post subject:

Centurion

Joined: 10 Jan 2011
Posts: 124

CREATE FUNCTION SortLettersInWord (IN input CHARACTER) RETURNS CHARACTER
BEGIN

DECLARE chOut CHARACTER '';
DECLARE lenCh INTEGER LENGTH(input);
DECLARE cnt,cnt2 INTEGER 1;
DECLARE posStr INTEGER 1;

WHILE cnt<=lenCh DO

-- Get the Character to be traversed.
DECLARE getCh CHARACTER SUBSTRING(input FROM posStr FOR 1);

-- Get the least possible letter.
WHILE cnt2<=lenCh DO
DECLARE preCh CHARACTER SUBSTRING(input FROM cnt2 FOR 1);
IF preCh <=getCh THEN
set chOut= preCh||chOut;
END IF;
SET cnt2=cnt2+1;
END WHILE;
SET posStr=posStr+1;
SET cnt=cnt+1;
END WHILE;

RETURN chOut;
END;

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Sort letters in word in alphabetical order

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP