Hello,
There are some problems that exist at least when set database to DB2 zOS/UDB option in "General Options" tab:
1) Long comment lines are not formatted - stay with their original length when "Max Line Length is set.
For DB2 zOS, the standart line length is 80 chars, long strings will not work in terminals, SPUFI, etc.
2) No new line before CREATE.
for example - before CREATE VIEW statement.
I was not able to find a possibility to add/remove a New Line option before my own keywords (tried to define CREATE, IS).
"IS" - is used not only in "IS NULL" / conditional clause, but also in COMMENT declaration.
For comments it would be good to have a possibility to leave "IS" together with "COMMENT ON ..." clause if max line length allows,
for example:
COMMENT ON COLUMN schema.tablename.columnname IS
'This is a column comment line".
But the #1 issue is much more critical of course, if there are ~100+ columns in a view, and if to edit DDL for many such views,
it is difficult to format long comments manually.
Are there any chances to get it fixed?
Thank you!
I use Notepad single user license , SQLInForm version 6.22.06.04
