Universal Cache User Guide : Tools and utilities : Instance and subscription management tools : ucpassthrough: SQL passthrough setup sample
  
ucpassthrough: SQL passthrough setup sample
The ucpassthrough sample creates two solidDB® databases (frontend and backend), the corresponding IBM InfoSphere CDC instances and datastores, and the subscription between them. The sample then inserts data into the backend database using the SQL passthrough feature.
The ucpassthrough sample uses the dminstancemanager utility to create the frontend and backend instances and the dmsubcriptionmanager utility to create the subscription. The sample also utilizes standard IBM InfoSphere CDC dm-commands, for example, to start the instances. SQL statements are used to pass through statements that insert and read data in the backend database.
The ucpassthrough sample script is available in the <IBM InfoSphere CDC for solidDB® installation directory>\samples\ucpassthrough directory. For a detailed description of how to use the sample, see the readme.txt in the same directory.
See also
Instance and subscription management tools