Hi All

i have to add a field in the sortlist ouput sortlist DATE TIME SYSTEM 'logon'

i want to define a variable to have the fixed value 'logon' or add column header to value 'logon' in the sortlist

can anyone help me in this?

thanks

Hello,

Hopefully these examples will help (the first one is based on an example from the CARLa manual):

DEFINE type=smf element(HB ,"logon",7) TRUE

define type=smf a_fixed_value("logon", str$blank("logon "),6) true

Regards, Mike

Thanks Mike for your support

actually my problem is i have field contains 0 or 2 or 3

if 0 i should display logon

if 2 should display logoff

if 2 should should display termination

is there any code to handle this case in one variable in sortlist?

This cannot be handled in one variable, but you can append multiple variables as follows to show the relevant values as per the define definitions, something like this:

define type=smf also_a_logon("lo",str$blank("logon "),6) boolean where ,

user='.......0'b

define type=smf also_a_logoff("go",str$blank("logoff"),6) boolean where ,

user='.......1'b

define type=smf also_a_term("n",str$blank("term "),6) boolean where ,

user='......1.'b

newlist type=smf outlim=1

select exists(user)

sortlist also_a_logon(0) | also_a_logoff(0) | also_a_term(0)