I am using variables in a sql statement. The default value contains spaces and sql keywords like "with" and "and". If I format the sql, the "keywords" in my text are changed an the line break is wrong.
Statment before formatting:
INSERT INTO MYSCHEMA.MYTABLE (ID, TEXT)
VALUES ($$ID||1001||BigDecimal||pk ds=22 dt=NUMERIC$$, $$ART||My text with spaces and sql keywords.|| String|| nullable ds=255 dt=VARCHAR$$)
Statement after formatting: (line width:90)
INSERT
INTO MYSCHEMA.MYTABLE
(
ID, TEXT
)
VALUES
(
$$ID||1001||BigDecimal||pk ds=22 dt=NUMERIC$$, $$ART||My text WITH spaces
AND SQL keywords.|| String|| nullable ds=255 dt=VARCHAR$$
)
The "sql keywords" were changed and a line break and spaces were added:
'My text WITH spaces
AND SQL keywords.'
