Create a method - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Usage

Creates a data transformation method, a procedure that changes the source data as it is being distributed to accommodate the needs and requirements at target servers.

Syntax
CREATE METHOD method-name FUNCTION function-name
   LANGUAGE JAVA_LANGUAGE
   [ARGUMENTS ( [optname] java-data-type, ...)]
   RETURNS sql-data-type
   [BODY ‘body of method-embed single quotes by doubling; use ^^ for CRLF’]
   [DESCRIPTION ‘descriptive text’]
   ;

The available Java datatypes are:

  • BOOLEAN

  • CHAR

  • DECIMAL (m, n)

  • DOUBLE

  • INTEGER