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
Hi kbowner,
many thanks for your feedback.
I will investigate if I can add linebreaks for comments. Could you please post one or two examples. This will avoid misunderstanding 🙂
I will also have a look why the CREATE view statement ist not starting on a new line
Regards
Guido
Hi kbowner,
could you also please send me an example where there is no linebreak for "CREATE VIEW". I just gave it a try and it worked
Regards
Guido