Forum Post: Re: Sqlwidthupdate In 11.6

  • Thread starter Thread starter Dmitri Levin
  • Start date Start date
Status
Not open for further replies.
D

Dmitri Levin

Guest
And here is how -SQLWidthUpdate works I have "test-sql-width" table with "char-1" field format "x(8)" sql MAX-WIDTH 16 and it has long string values more then 16 characters. First time I execute "select" I get abbreviated strings to first 16 characters. SQLExplorer>select * from PUB."test-sql-width"; char-1 ---------------- This is a long s An other long st At the same time schema is updated and now MAX-WIDTH 39, because the longest string I have is 39 characters. The second time execute "select" I get all my data. SQLExplorer>select * from PUB."test-sql-width"; char-1 --------------------------------------- This is a long string that should break An other long string for test I did not logout, just executed it a second time.

Continue reading...
 
Status
Not open for further replies.
Back
Top