Problems in DB2 zOS/UDB format rule (not formatted long comments, no new line before CREATE)

4 Posts
2 Users
0 Likes
142 Views
(@kbowner)
Member
Joined: 2 years ago
Posts: 1
Topic starter  

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


   
Quote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 170
 

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


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 170
 

Hi kbowner

just tried to reproduce your case

SQL before formatting

grafik

SQL after formatting

grafik

It looks like the split of the comment is working fine.

If it still does not work on your side, please export your formatting profile and send it to me via mail

Regards

Guido


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 170
 

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


   
ReplyQuote
Share: