Very Computer

Hello,
We are on V3R6 and PTF level 254 (model 400).

SQL statement COMMENT ON COLUMN does not work at all.
SYSCOLUMNS table's column LONG_COMMENT contains no data after
statement:

Quote:> COMMENT on column MSSCLL/BRAND.grad is 'HELLUREI'

I'v checked both SYSCOLUMNS tables (in QSYS2 and in our collectio libs).

Any ideas of this ?

We also had problems with system cross reference tables. RCLSTG did not
fix them if our collection existed during RCLSTG operation.
--
Toni H?kk?nen

UPM-Kymmene, Kaukas
Lappeenranta Paper Mill

You have found a problem with the SQL COMMENT ON support,
report this problem to IBM Service the SQL group is going
to start working on a V3R6 PTF.

|> Hello,
|> We are on V3R6 and PTF level 254 (model 400).
|>
|> SQL statement COMMENT ON COLUMN does not work at all.
|> SYSCOLUMNS table's column LONG_COMMENT contains no data after
|> statement:
|>
|> > COMMENT on column MSSCLL/BRAND.grad is 'HELLUREI'
|>   COMMENT ON for BRAND in MSSCLL completed.        
|>
|> I'v checked both SYSCOLUMNS tables (in QSYS2 and in our collectio libs).
|>
|> Any ideas of this ?
|>
|> We also had problems with system cross reference tables. RCLSTG did not
|> fix them if our collection existed during RCLSTG operation.
|> --
|> Toni H?kk?nen
|>
|> UPM-Kymmene, Kaukas
|> Lappeenranta Paper Mill

--
Kenton Milligan
DB2/400 Development
IBM Rochester-AS/400 Division

GO HAWKEYES!!
(opinions stated are not necessarily those of my employer)

Re: SQL statement COMMENT ON problem for columns

SF33726 claims to fix something similar

Chuck Pence
 -- Comments provided "as is" with no warranties of any kind whatsoever.