After establishing a connection, load or export data from the database. Data can be loaded on a row by row basis using the PutRow function or as a block by using the PutBuffer function which is available to the Load, Update, and Stream drivers. Likewise, data can be exported one row at a time using the Export driver’s GetRow function or multiple rows can be exported together in a buffer using the Export driver’s GetBuffer function.
Data can be loaded into or exported from all of the columns in a table, or from a subset of the columns in a table. When loading data into a subset of the columns in a table, default values must be specified for the columns not being loaded. In each case, only the columns being loaded or exported from should be defined in the schema.
For example, Table1 has columns A, B, and C. Columns A and B are defined as integers and column C is a variable character column with a length of 25. To load data into column A only, a valid insert statement would be:
INSERT INTO Table1 (A, B, C) VALUES (:A, 0, NULL);
where zero is the default value for B and NULL is the default value for column C. The input schema for this example would be defined as only having column A.