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.
SAP Knowledge Base Article - Preview