3206803 - The session level option is not working when using it with execute statement - SAP ASE

The result of this script is different if the 'execute' statement is used or not used.

• script 1
     
  set ansinull on
  if (object_id("abc") = NULL)
  begin
  print "OBJECT NOT FOUND"
  end
  else
  begin
  print "OBJECT FOUND"
  end
  go
  
  OBJECT FOUND
     
• script 2
     
  execute ('set ansinull on')
  if (object_id("abc") = NULL)
  begin
  print "OBJECT NOT FOUND"
  end
  else
  begin
  print "OBJECT FOUND"
  end
  go
  
  OBJECT NOT FOUND
  

SAP Adaptive Server Enterprise (ASE) 

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To