RPAD equivalent in db2

tithisona · #1 (**permalink**) 05-19-09, 09:29

i need to know the db2 equivalent query of the following:

RPAD( string,17,'X')

ARWinner · #2 (**permalink**) 05-19-09, 12:30

Maybe if you told us what it does. Also what DB2 version and OS.

Andy

Stealth_DBA · #3 (**permalink**) 05-19-09, 12:56

tithisona, if RPAD(string, 17,'X') means pad the string with 17 'X' to to the right, you might use:

string CONCAT REPEAT('X',17)

norbertogf · #4 (**permalink**) 05-19-09, 14:05

You coud create an UDF for that, as I do:

Code:

CREATE FUNCTION rpad(
    arg VARCHAR(4000), 
    pad VARCHAR(1), 
    len INTEGER) RETURNS VARCHAR(40)
SPECIFIC rpad
CONTAINS SQL
DETERMINISTIC
NO EXTERNAL ACTION
RETURN arg || REPEAT(pad, len - LENGTH(arg))
;

Hope it helps...

Internet Services

Web Development

Digital Marketing

Consumer Tech