Symptom
- In ASE 15.7 SP130 and above, the str_replace function produces much wider output than in previous versions.
- This behavior can be seen in a view, but it is not limited to views:
1> sp_help mytest_view
2> go
Name Owner Object_type Object_status Create_date
------------------- -------- ------------- ----------------- -------------------
mytest_view dbo view -- none -- Sep 24 2015 8:36AM
Column_name Type Length Prec Scale Nulls Not_compressed Default_name Rule_name Access_Rule_name Computed_Column_object Identity
-------------------- -------- ------- ----- ------- ------- ------------------- ------------------ -------------- ---------------------- ----------------------------- ---------
SOURCE_DATABASE varchar 1024 NULL NULL 1 0 NULL NULL NULL NULL 0
No defined keys for this object.
- In previous versions, the varchar would be expected to be varchar(10), instead of varchar (1024).
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
pattern string, replacement strings , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.