SYSREMOTEUSERS 统一视图

SYSREMOTEUSERS 视图的每一行都描述一个具有 REMOTE 权限的用户 ID（预订者），以及发送自/至该用户的 SQL Remote 消息的状态。

在以下的 SQL 语句中提供了组成该视图的表和列。要了解有关特定表或列的详细信息，请使用该视图定义下所提供的链接。

ALTER VIEW "SYS"."SYSREMOTEUSERS"
  as select u.user_name,r.consolidate,t.type_name,r.address,r.frequency,
    r.send_time,
    (if r.frequency = 'A' then null else if r.frequency = 'P' then
        if r.time_sent is null then current timestamp
        else(select min(minutes(a.time_sent,60*hour(a.send_time)
            +minute(seconds(a.send_time,59))))
            from SYS.ISYSREMOTEUSER as a where a.frequency = 'P'
            and a.send_time = r.send_time)
        endif
      else if current date+r.send_time
         > coalesce(r.time_sent,current timestamp) then
          current date+r.send_time else current date+r.send_time+1 endif
      endif endif) as next_send,
    r.log_send,r.time_sent,r.log_sent,r.confirm_sent,r.send_count,
    r.resend_count,r.time_received,r.log_received,
    r.confirm_received,r.receive_count,r.rereceive_count
    from SYS.ISYSREMOTEUSER as r
      join SYS.ISYSUSER as u on(u.user_id = r.user_id)
      join SYS.ISYSREMOTETYPE as t on(t.type_id = r.type_id)

另请参见

使用DocCommentXchange讨论此页。