IBM InfoSphere DataStage, Version 11.3.1
SPACE function
Syntax
SPACE (expression)
Description
Use the SPACE function to return a string composed of blank spaces. expression specifies the number of spaces in the string. If expression evaluates to the null value, the SPACE function fails and the program terminates with a run-time error message.
There is no limit to the number of blank spaces that can be generated.
Example
PRINT "HI":SPACE(20):"THERE"
*
*
VAR=SPACE(5)
PRINT "TODAY IS":VAR:OCONV(DATE(),"D")
This is the program output:
HI THERE
TODAY IS 18 JUN 1992
Last updated: 2015-03-09
PDF version of this information: