[OT] User-Defined string Functions SQL Procedural Language DB2

User-Defined string Functions SQL Procedural Language DB2
Ladies and Gentlemen,

I am pleased to offer, free of charge, the following string functions SQL Procedural Language DB2:

AT(): Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character.
RAT(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string.
OCCURS(): Returns the number of times a character expression occurs within another character expression (including overlaps).
OCCURS2(): Returns the number of times a character expression occurs within another character expression (excluding overlaps).
PADL(): Returns a string from an expression, padded with spaces or characters to a specified length on the left side.
PADR(): Returns a string from an expression, padded with spaces or characters to a specified length on the right side.
PADC(): Returns a string from an expression, padded with spaces or characters to a specified length on the both sides.
CHRTRAN(): Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression.
STRTRAN(): Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. Unlike a built-in function Replace, STRTRAN has three additional parameters to help refine searches.
STRFILTER(): Removes all characters from a string except those specified.
GETWORDCOUNT(): Counts the words in a string.
GETWORDNUM(): Returns a specified word from a string.
GETALLWORDS(): Inserts the words from a string into the table.
PROPER(): Returns from a character expression a string capitalized as appropriate for proper names.
RCHARINDEX(): Similar to the SQL PL function LOCATE, with a Right search.
ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified numeric expression (from 1 to 3999).
ROMANTOARAB(): Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX).

AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP.

Plus, there are CHM files in English, French, Spanish and German.

Plus, there are versions for MS SQL SERVER, SYBASE ASA, Oracle, MS SQL SERVER 2005 SQLCLR.

More than 1 000 people have already downloaded my DB2 functions. I hope you will find them useful as well.

For more information about string UDFs SQL Procedural Language DB2 please visit the
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,29032

Please, download the file
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,29032

With the best regards,
Igor Nikiforov
P.S.
I would like to tell you a bit about myself.
I am an author of User-defined string functions. Each day my functions are
downloaded on average by 30 people from around the world.
More than 16 000 people have already downloaded my functions.
My functions include versions for MS SQL Server (7.0, 2000, and 2005),
MS SQL Server 2005 CLR .Net, Sybase ASA, DB2 and Oracle.
I would like to bring to your attention that I found errors in the
MS SQL Server, Sybase and DB2, which attests to the quality of my work.