Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    2

    Unanswered: about traceflag 4048

    Hi,

    I want to know the detail of traceflag 4048, anyone knows pls show it.

    ths.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Quote from
    http://www.isug.com/Sybase_FAQ/ASE/S...4/Q10.4.9.html

    Release 11.0.3.2 fixes include:

    CR Description

    137849 Add boot time trace flag 4048 to revert to 2-digit year in the error log.

  3. #3
    Join Date
    Jun 2008
    Posts
    2
    hi, pdreyer,

    thanks a lot.
    I want to know traceflag 4048 in ASE 12.5.

    In some document, I found the followings,
    "There is a documented change starting with ASE 11.5 where we no longer truncate trailing spaces for CHAR datatypes in string functions.
    Trace flag # 4048 Revert trailing space and variable function behavior to pre-11.5 version."


    Do you konw any more detail about it ?

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Indeed; This is a documented change with ASE 11.5 onwards where the behavior of many of the string functions is different because of a rewrite to conform with ANSII standards. See
    What's New in Sybase(R) Adaptive Server(TM) Enterprise? (Document ID: 36440-01-1150)
    Chapter 2 System Changes in Adaptive Server Release 11.5
    Trailing Spaces of char Data No Longer Truncated in String Functions

    The following example demonstrates this change in behavior:
    Code:
    select 'x'+upper(convert(char(5),'abc'))+'x'
    
    Pre-11.5 releases produced a char(5): "xABCx". 
    Adaptive Server produces a char(7): "xABC  x".
    Boot up ASE with traceflag 4048 which revert trailing space and datalength function behavior to that of pre-11.5.
    Not suggested as this traceflag may be removed in the future release.
    use varchar instead e.g.
    Code:
    select 'x'+upper(convert(varchar(5),'abc'))+'x'
    However, Trace Flag 4048 is still in the ASE 12.5.1 codeline.
    Last edited by pdreyer; 06-23-08 at 04:53. Reason: Rather use varchar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •