Please enable JavaScript to view this site.

Example 1

Simple JSON formatted file or HDFS (Hadoop file system) where every source object name (i.e. table name) will become a file name.

REPLICATE

  DB2 cdc://<host_name>:<sqdaemon_port>/<publisher_name>/<subscription_name>

  TO JSON [file | hdfs]:///*/key

;

 

Example 2

Simple JSON formatted file or HDFS (Hadoop file system) where every source object name (i.e. table name) is written to a specified file name with a common prefix and suffix.

REPLICATE

  DB2 cdc://<host_name>:<sqdaemon_port>/<publisher_name>/<subscription_name>

  TO JSON [file | hdfs]:///<prefix>_*_<suffix>/key

;