|
Each row in the SYSSYNCSCRIPTS view identifies a stored procedure for MobiLink scripted upload. This view is almost identical to the SYSSYNCSCRIPT system view, except that the values are in human-readable format, as opposed to raw data.
ALTER VIEW "SYS"."SYSSYNCSCRIPTS"
as select p.publication_name,
t.table_name,
case s.type
when 0 then 'upload insert'
when 1 then 'upload delete'
when 2 then 'upload update' else 'unknown'
end as type,
c.proc_name from
SYS.ISYSSYNCSCRIPT as s join
SYS.ISYSPUBLICATION as p on p.object_id = s.pub_object_id join
SYS.ISYSTAB as t on t.object_id = s.table_object_id join
SYS.ISYSPROCEDURE as c on c.object_id = s.proc_object_id