Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

¹ØÓÚͬ²½£¬aseºÍsp_hook_dbmlsync_end

2 posts in iAnywhere General Discussion (Chinese) Last posting was on 2007-03-19 23:21:50.0Z
yw Posted on 2007-02-23 15:04:28.0Z
From: "yw" <yang_delp@163.com>
Newsgroups: ianywhere.public.chinese.general
Subject: ¹ØÓÚͬ²½£¬aseºÍsp_hook_dbmlsync_end
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 222.129.218.182
X-Original-NNTP-Posting-Host: 222.129.218.182
Message-ID: <45df027c@forums-1-dub>
Date: 23 Feb 2007 07:04:28 -0800
X-Trace: forums-1-dub 1172243068 222.129.218.182 (23 Feb 2007 07:04:28 -0800)
X-Original-Trace: 23 Feb 2007 07:04:28 -0800, 222.129.218.182
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:827
Article PK: 4054

µ÷Á˺þã¬Ã»Óе÷³öÀ´£¬¸÷λ¸ßÊÖÄÄλÄÜ°ï°ï棬ÔÚaseÖÐǶÈëasaµÄmoblinkÀÊÇ·ñ
ÄܹҽÓsp_hook_dbmlsync_end,
ÒÔÏÂÊÇÎÒдµÄͬ²½¹ý³Ì²¿·Ö£¬Ö÷ÒªÊÇÏëÖªµÀ¿Í»§¶ËÓû§µÄͬ²½Çé¿ö£¬Êdzɹ¦»¹ÊÇʧ°Ü£¬
Èç¹û´Ë·½·¨²»ÄÜʵÏÖ£¬ÊÇ·ñ¿Éͨ¹ýÆäËü·½Ê½ÊµÏÖ£¬
ÒÔÏ´洢¹ý³ÌÔÚasaÖÐûÓÐÎÊÌ⣬²»ÖªµÀÔõôÒÆÖ²ÖÁaseÖУ¬ÊÇ·ñase²»Ö§³Ö´ËÏÄÜ£¬
ASA--ALTER procedure lyjdb.sp_hook_dbmlsync_end()
begin
declare @mob_type integer;
declare @l_result integer;
declare @l_mluser char(10);
select value into @l_result from #hook_dict where name = 'Exit code';
select value into @l_mluser from #hook_dict where name = 'Mobilink user';
if @l_result = 0 then
insert into mob_recs(m_id,end_time,mob_result,para_id)
values(@l_mluser,getdate(*),'³É¹¦',@mob_type)
end


Raymond.Kwong Posted on 2007-03-19 23:21:50.0Z
From: Raymond.Kwong@sybase.com
Subject: Re: ¹ØÓÚͬ²½£¬aseºÍsp_hook_dbmlsync_end
Newsgroups: ianywhere.public.chinese.general
MIME-Version: 1.0
References: <45df027c@forums-1-dub>
X-Newsreader: Lotus Notes Release 6.5 September 26, 2003
X-MIMETrack: Serialize by Notes Client on Raymond Kwong/SYBASE(Release 6.5|September 26, 2003) at 03/19/2007 07:21:46 PM, Serialize complete at 03/19/2007 07:21:46 PM
Content-Type: multipart/alternative; boundary="=_alternative 0080562C852572A3_="
NNTP-Posting-Host: rkwong-xp.sybase.com
X-Original-NNTP-Posting-Host: rkwong-xp.sybase.com
Message-ID: <45ff1b0e@forums-1-dub>
Date: 19 Mar 2007 15:21:50 -0800
X-Trace: forums-1-dub 1174346510 10.25.98.158 (19 Mar 2007 15:21:50 -0800)
X-Original-Trace: 19 Mar 2007 15:21:50 -0800, rkwong-xp.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:834
Article PK: 557


sp_hook_dbmlsync_end 是应用於dbmlsync连接的远程数据库,故此并不能直接应用於ASE里。

正常情况下你需要在ASA创建mob_recs表,然後把它放进另一publication里,用dbmlsync -n 把该publication里的mob_recs资料与ASE同步。

当然若mob_recs洽考是一个直接连结到中央数据库的代理表,又会当作别论。