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 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |