angoca/db2tools

Adds extra spaces for schema with less than 8 chars.

Opened this issue · 0 comments

DECLARE SIZE SMALLINT;
SET SIZE = LENGTH(SCHEMA_NAME);
WHILE (SIZE < 8) DO
SET SCHEMA_NAME = SCHEMA_NAME || ' ';
SET SIZE = LENGTH(SCHEMA_NAME);
END WHILE;
RETURN SCHEMA_NAME;