SQL Reference

REPEAT

>>-REPEAT--(--expression--,--expression--)---------------------><

The schema is SYSFUN.

Returns a character string composed of the first argument repeated the number of times specified by the second argument.

The first argument is a character string or binary string with a maximum length of 1048576 bytes. The second argument can be SMALLINT or INTEGER.

The result of the function is:

• VARCHAR(4000) if the first argument is VARCHAR or CHAR

• CLOB(1M) if the first argument is CLOB or LONG VARCHAR

• BLOB(1M) if the first argument is BLOB.

The result can be null; if any argument is null, the result is the null value.

Example:

• List the phrase 'REPEAT THIS' five times.

  VALUES CHAR(REPEAT('REPEAT THIS', 5), 60)
  

  This example return the following:

  1                                                           
  ------------------------------------------------------------
  REPEAT THISREPEAT THISREPEAT THISREPEAT THISREPEAT THIS     
  

  As mentioned, the output of the REPEAT function is VARCHAR(4000). For the above example the function CHAR has been used to limit the output of REPEAT to 60 bytes.

[ DB2 List of Books | Search the DB2 Books ]