Subject RE: [IBO] Ibo replication
Author Jason Wharton
This looks like a failing to process the macro substitutions in the
replication metadata load process. This must be a problem in the build I
just did for you. I didn't test that build before I sent it to you.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Daniel Jimenez
> Sent: Tuesday, May 08, 2007 11:16 PM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Ibo replication
>
>
> Hi Jason,
>
> Following the Tutorial, I have created a DB called Source,
> with a single
> table
>
> RECREATE TABLE MEMBERS
> (
> ID NUMERIC( 18, 0) NOT NULL,
> NAME VARCHAR( 50) NOT NULL COLLATE NONE,
> CONSTRAINT PK_MEMBERS PRIMARY KEY (ID)
> );
>
> I have also created another Db called Destination, which has no tables
> defined.
>
> Now as per the tutorial I have added the latest Windows
> version of Gregory
> Deatz' FreeUDFLib library to the server and to declare the
> User-Defined
> Function (UDF) F_BLOBBINCMP on the SOURCE DB.
>
> DECLARE EXTERNAL FUNCTION F_BLOBBINCMP
> BLOB, BLOB
> RETURNS INTEGER BY VALUE
> ENTRY_POINT 'BlobBinCmp' MODULE_NAME 'freeudflib.dll';
>
>
> So far no problems. Step 2 - "Configuring and loading Indexes for
> Replication" works fine until you get to the point where you
> click the "Load
> Metadata" button. At this point I get the following error Message:
>
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 26, char 11
> )
>
> STATEMENT:
> TIB_DSQL: "IBO_DefaultSession.dmRPL_Scripts.scSRCLoadMeta.<TIB_DSQL>."
>
> If you select the SQL tab in the Error dialog window, you get :
>
> CREATE TRIGGER RPL$<<IND_NME>>$Q_AU
> FOR <<SRC_TBL_NME>>
> AFTER UPDATE
> AS
> DECLARE VARIABLE Q_TYP CHAR( 1 );
> <<SRC_TRG_DEC_VAR>>
> <<SRC_BLA_DEC_VAR>>BEGIN
> Q_TYP = 'U';
> IF ( <<SET_EXP_NEW>><<SRC_ADD_EXP>> ) THEN
> BEGIN
> IF ( NOT ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> )) THEN
> BEGIN
> <<CUSTOM_SRC_Q_INS_TRG>>
> END
> ELSE
> IF ( <<SRC_UPD_EXP>> ) THEN
> BEGIN
> <<SRC_BLA_INIT_VAR>><<SRC_BLA_SET_VAL_AU>>
> <<CUSTOM_SRC_Q_UPD_TRG>>
> END
> END
> ELSE
> IF ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> ) THEN
> BEGIN
> <<CUSTOM_SRC_Q_DEL_TRG>>
> END
> END
>
> Help would be much appreciated, as I am not sure what is the
> problem(s)
>
> Thanks
>
> Daniel