Tag Archive: Cincom VisualWorks

Array Binding and Array Fetching in ODBC Connects

Yuwei Li recently wrote:

Some databases and their ODBC drivers allow clients to control the number of rows that will be physically transferred between the server and the client in one logical bind or fetch. These features are called array binding and array fetching. Using array binding and array fetching can greatly improve the performance of many applications by trading buffer space for time (network traffic).

From Cincom® ObjectStudio® 8.4 and Cincom® VisualWorks® 7.9, Cincom starts to support array binding and array fetching in ODBC connects.

Support of Oracle PL/SQL REF CURSORs and Nested Tables

From Cincom® VisualWorks® 7.8 and Cincom® ObjectStudio® 8.3, Cincom starts to support Oracle PL/SQL REF CURSORs and Nested Tables.

Nested Table is an Oracle data type used to support columns containing sub-tables. PL/SQL REF CURSORs is a data structure pointing to the result set of the sub-tables.