Skip to Content
0
May 25, 2018 at 03:28 PM

NULL value for loginame sysobjects

142 Views

Hello,

Running ASE 16 SP02 on HP-UX , when trying to look for the login creator of some SP, the output for loginame shows NULL . Example:

use pubs2

go

select substring(name,1,20),type,crdate,substring(loginame,1,20) from sysobjects where

crdate >= "2018/01/01 00:00:01" and crdate <= "2018/04/30 23:59:59"

go

type crdate

---------------------------------------- ---- ------------------------------- ----------------------------------------

P1 P Apr 4 2018 9:49AM NULL

sp1 P Apr 25 2018 9:48AM NULL

sp2 P Apr 25 2018 9:53AM NULL

Is this a normal behaviour ?

Thank you

Jose