Returns a specified number of spaces.
LONG VARCHAR
The result data type is a LONG VARCHAR. If you use SPACE in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set SPACE to the correct data type and size.