Re: Does DB2/400 have REPEAT function like PLSQL in Oracle?

[CRPence <crp@xxxxxxxxxxxxxxxxxxxx>]

  REPEAT is documented as a Scalar Function.
    >>-REPEAT--(--expression--,--integer--)----------><
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstscale.htm

  I did not see anything like the described LPAD for an available SQL 
scalar in the DB2 for i5/OS.

  Note that if the given expression is meant to match the ORACLE 
function, and especially if moved into a UDF, then be sure to use the 
MIN scalar to avoid errors; i.e. positive integer or zero, is required 
for REPEAT().  In any case, consider casting the result of the given 
expression to the desired & expected type/length attributes.  The given 
expression is likely to produce a VARCHAR of a large length.

  The given expression uses CHAR() which may be unnecessary.?  Perhaps 
if the "location ID" is numeric, such that the char() might then be 
perceived as necessary, then try instead, a simpler left-pad with zeros:
    DIGITS(CAST(Location_ID as DECIMAL(9, 0)) AS Location_ID

Regards, Chuck