Oninit cdi / Archive
Talk to an expert →

error on define ER replicate

Posted in 2007

Topics: Storage & Space Management, Stored Procedures & SPL, Platform-Specific Issues, Internationalization & Character Sets

FRANK — — source: IIUG Forums & Mailing Lists

Hi, The following definition is successfull if I use "ignore" conflict rule, but falied if choose "always-apply"(see attached info), any idea? Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 Thanks, Frank create table "informix".abc_test ( id serial not null , name char(10) not null , dt datetime year to second default current year to second, primary key (id,name) constraint "informix".abc_test_pk ) with crcols extent size 32 next size 32 lock mode row; cdr define replicate --conflict=always-apply --ats --ris abc_test_repl \\\\ "noaa@osdint1_grp:informix.abc_test" "select * from abc_test" \\\\ "noaa@ncdcprd_grp:informix.abc_test" "select * from abc_test" command failed -- SPL routine does not exist. (38)

↪ replying to FRANK
Madison Pruet — — source: IIUG Forums & Mailing Lists

You might want to check the doc on the syntax for always apply = "FRANK" = <yunyaoqu@gmail.c = om> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect error on define ER replicate [81= 08] 01/04/2007 09:59 = AM = = = Please respond to = ids@iiug.org = = = Hi, The following definition is successfull if I use "ignore" conflict rule= , but falied if choose "always-apply"(see attached info), any idea? Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 Thanks, Frank create table "informix".abc_test ( id serial not null , name char(10) not null , dt datetime year to second default current year to second, primary key (id,name) constraint "informix".abc_test_pk ) with crcols extent size 32 next size 32 lock mode row; cdr define replicate --conflict=3Dalways-apply --ats --ris abc_test_rep= l \\\\ "noaa@osdint1_grp:informix.abc_test" "select * from abc_test" \\\\ "noaa@ncdcprd_grp:informix.abc_test" "select * from abc_test" command failed -- SPL routine does not exist. (38) ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to FRANK
Nilesh Ozarkar — — source: IIUG Forums & Mailing Lists

correct syntax is --conflict=always Regards, Nilesh "FRANK" <yunyaoqu@gmail.com> Sent by: ids-bounces@iiug.org 01/04/2007 09:59 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject error on define ER replicate [8108] Hi, The following definition is successfull if I use "ignore" conflict rule, but falied if choose "always-apply"(see attached info), any idea? Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 Thanks, Frank create table "informix".abc_test ( id serial not null , name char(10) not null , dt datetime year to second default current year to second, primary key (id,name) constraint "informix".abc_test_pk ) with crcols extent size 32 next size 32 lock mode row; cdr define replicate --conflict=always-apply --ats --ris abc_test_repl \\\\ "noaa@osdint1_grp:informix.abc_test" "select * from abc_test" \\\\ "noaa@ncdcprd_grp:informix.abc_test" "select * from abc_test" command failed -- SPL routine does not exist. (38) ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary