Database Connectivity - Advanced (G Dataflow)

Execute queries, create parameterized queries, interact with recordsets, get and set parameter values, and perform other advanced operations.

Create Parameterized Query

Creates a structured SQL query statement that accepts a value or array of values.

Execute Query

Executes an SQL query and returns a reference.

Fetch Element Data

Retrieves the data at the column index of the record in the Recordset that you specify.

Fetch Next Recordset

Retrieves the next Recordset in a multi-Recordset query.

Fetch Recordset Data

Retrieves the data in the Recordset you specify.

Free Object

Frees an object by closing its reference.

Get Parameter Value

Retrieves the value of the parameter you specify.

Move to Next Record

Points the cursor to the next record in the Recordset you specify with the reference input.

Move to Previous Record

Points the cursor to the previous record.

Move to Record N

Points the cursor to record n in the Recordset.

NULL

Returns a database NULL value.

Set Parameter Value

Sets the value of the parameter at the index you specify with the parameter index input.