Category "dynamicquery"

Crafting a Subquery-able UNION ALL based on the results of a query

Data I have a couple of tables like so: CREATE TABLE cycles ( `cycle` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cycle_type` varchar(140) COLLATE

Azure Logic Apps: How to use variables in a dynamic query?

Trying to add values from the JSON Parser into a dynamic Oracle query but always shows up as blank/empty. Same results trying to use the formal parameters and d

Pentaho Kettle: Dynamic Parameters and Query

I am trying to insert a data to destinationDB from a dynamic datasource as well as its query in getting the data. That said the columns and table to insert may

Progress 4GL: Buffer handle attribute for all fields

I am fairly new to Progress and even newer to handles so apologies if I have missed anything obvious, I've looked online but am yet to find what I'm looking for