Download IBM Informix Dynamic Server Enterprise Replication Guide
Transcript
Enterprise Replication Data Types SPL Conflict Resolution for Simple Large Objects If the replicate is defined with an SPL conflict-resolution rule, the SPL routine must return the desired action for each BYTE or TEXT column. When the routine is invoked, information about each BYTE or TEXT column is passed to the routine as five separate fields. The following table describes the fields. Argument Description Column size (INTEGER) The size of the column (if data exists for this column). NULL if the column is NULL. BLOB flag [CHAR(1)] For the local row, the field is always NULL. For the replicated row: Column type [CHAR(1)] ID of last update server [CHAR(18)] ■ D indicates BYTE or TEXT data is sent from the source database server. ■ U indicates BYTE or TEXT data is unchanged on the source database server. ■ P indicates tablespace data. ■ B indicates blobspace data. The ID of the database server that last updated this column for tablespace data For blobspace data: NULL Last update time (DATETIME YEAR TO SECOND) For tablespace data: The date and time when the data was last updated. For blobspace data: NULL For information on creating stored procedures, see the IBM Informix Guide to SQL: Tutorial. If the routine returns an action code of A, D, I, or U, the routine parses the return values of the replicated columns. Each BYTE or TEXT column can return a two-character field. For information about the action codes, refer to “SPL Conflict-Resolution Rule” on page 3-14. 2-22 IBM Informix Dynamic Server Enterprise Replication Guide
Related documents
Guide to IBM Informix Enterprise Replication
Guide to Informix Enterprise Replication, Version 9.2
ACS-102 Sistema de Alarme via-rádio de 2 canais Manual
Guide to Informix Enterprise Replication, Version 7.3
IBM Informix Administrator`s Guide
here
IBM Informix Administrator`s Guide
IBM Informix Migration Guide
Performance Guide for IBM Informix Dynamic Server
Informix Backup and Restore Guide, December 1999
IBM Informix Administrator`s Reference
Manuale AS8 IT - METAU ENGINEERING srl