Why wide output for sp_configure output on ASE 16?

[sladebe]

With ASE 16, the output of sp_configure change to very wide (as compared to 15.5). It makes it difficult to read using a normal isql session.

It looks like the v16 sp_configure proc stopped using sp_autoformat when displaying the output for a "not unique" config param name and for a specific match config name param.

I was able to create a hacked version of sp_configure that calls sp_autoformat in a few minutes. So it's not that hard to fix, unless there's some other subtle reason why it won't work.

This is a real loss of functionality for a frequently used, core function. Why did it happen?

[former_member188958 · Accepted solution]

Hi Ben,

I don't know the history of the internals of sp_configure offhand, but I can report that it has been rewritten
for the 16.0 SP03 release to consistently use sp_autoformat throughout.

-bret

[sladebe]

FYI, ASE 16.0 SP03 (or ASE 16.0.03 as reported by @@sbssav) is available on the download site. And it *does* use sp_autoformat for sp_configure output. Yaaay!

[former_member188958]

Release of 16.0 SP03 is currently planned for June.

https://wiki.scn.sap.com/wiki/display/SYBASE/Targeted+ASE+16.0+Release+Schedule+and+CR+list+Informat...

-bret

[sladebe]

Ok, thanks for the info.

[sladebe]

Ok, thanks for the info. That's good to hear.

When I go to my downloads section, there's an ASE 16.0 entry there (item 5107759) with no specific version info. I even downloaded the .zip file for 5107759, but there's no easy to find version info that's more specific than "ASE 16.0". The release date for this entry is 29.06.2016 (June 29th 2016).

What's the release date for SP03? Ie., is it released/downloadable?

Thx