IBM Integration Bus, Version 9.0.0.8 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

SPACE function

SPACE is a string manipulation function that manipulates all data types (BIT, BLOB, and CHARACTER), and creates a string that consists of a defined number of blank spaces.

Syntax

Read syntax diagramSkip visual syntax diagram
>>---SPACE----(--NumericExpression--)--------------------------><

SPACE returns a character string that consists of the number of blank spaces that are given by NumericExpression. The parameter must be of type INTEGER; the result is of type CHARACTER.

If the parameter is negative or zero, a zero length character string is returned. If the parameter is NULL, the result is NULL.

The string is limited to 32*1024*1024 bytes (33 554 432 bytes) to protect the broker from erroneous programs. If this limit is exceeded, an exception condition is issued.


ak05251_.htm | Last updated Friday, 21 July 2017