Sybase Adaptive Server Anywhere - SYSREMOTEUSERS System View

SYSREMOTEUSERS system view
1068
SYSREMOTEUSERS system view
CREATE VIEW SYS.SYSREMOTEUSERS
AS SELECT(SELECT user_name FROM SYS.SYSUSERPERM AS u
WHERE u.user_id=r.user_id) AS user_name,
"consolidate",
(SELECT type_name FROM SYS.SYSREMOTETYPE AS t
WHERE t.type_id=r.type_id) AS type_name,
"address",frequency,send_time,
(IF frequency=’A’ THEN
NULL
ELSE
IF frequency=’P’ THEN
IF time_sent IS NULL THEN
current timestamp
ELSE
(SELECT min(minutes(time_sent,
60*hour(a.send_time)
+minute(seconds(a.send_time,59))))
FROM SYS.SYSREMOTEUSER AS a
WHERE a.frequency=’P’
AND a.send_time=r.send_time)
ENDIF
ELSE
IF current date+send_time
>COALESCE(time_sent,current timestamp) THEN
current date+send_time
ELSE
current date+send_time+1
ENDIF
ENDIF
ENDIF) AS next_send,
log_send,time_sent,log_sent,
confirm_sent,send_count,resend_count,
time_received,log_received,confirm_received,
receive_count,rereceive_count
FROM SYS.SYSREMOTEUSER AS r
Presents the information from SYSREMOTEUSER in a more readable
format.