SPACE
The SPACE function returns a character string that consists of the number of SBCS blanks that the argument specifies.
The schema is SYSIBM.
- numeric-expression
- An expression that returns the value of any built-in integer data
type. The expression specifies the number of SBCS blanks for the result,
and it must be between 0 and 32767.
The argument can also be a character string or graphic string data type. The string input is implicitly cast to a numeric value of DECFLOAT(34) which is then assigned to a BIGINT value.
The result of the function is a varying-length character string (VARCHAR) that contains SBCS data.
If numeric-expression is a constant, the length attribute of the result is the constant. Otherwise, the length attribute of the result is 4000. The actual length of the result is the value of numeric-expression. The actual length of the result must not be greater than the length attribute of the result.
The result can be null; if the argument is null, the result is the null value.
SELECT SPACE(5), SPACE(0)
FROM SYSIBM.SYSDUMMY1;