Welcome to the IBM TechXchange Community, a place to collaborate, share knowledge, & support one another in everyday challenges. Connect with your fellow members through forums, blogs, files, & face-to-face networking.
IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
Download the slides below.You can watch the full recording here.Feel free to ask any questions you have here. Aggregate and generate real-time reports on OLTP data with zero impact to OLTP applications and without polluting buffer pool with expensive analytic queries. Other use cases include 1) Data transformations 2) Update external systems like MQTT, Hadoop and Graph databases 3) Replicate data for tables that do not have primary key, unique index or ER key.
Common Table Expressions (CTE) are a SQL standard feature, CTE simplify queries and make queries more readable. Use recursive CTE to query hierarchical data, and tree/graph structured data. Also, you can do programming tasks with CTE.
Join this session to hear more about and see a demo with Informix 14.10 release support of: