Populating Tables
Methods of Populating Tables
You can load data into tables using the following methods:
• COPY statement
The COPY statement is a good method to use for loading large quantities of data quickly from files, and is flexible in dealing with record formats.
• INSERT statement
Use the INSERT statement to enter a small amount of data.
• Append mode of Query-By-Forms (QBF)
Use QBF for interactive data entry.
• FASTLOAD command
Use the FASTLOAD command for high speed loading of unformatted data from a file. FASTLOAD is much less flexible than COPY, and is designed for specialized loading situations. Not valid for X100 tables.
• IngresConnect, a version of DataConnect for Ingres users, provides a graphical way of loading data from a flat file or database. It is not recommended for large scale data ingestion.
To use IngresConnect, you must download Actian DataConnect 11.0 and access the IngresConnect connectors for flat files and databases.
For more information, see the
Using IngresConnect Sample Projects. Alternatively, after installing DataConnect, click Help, Help Contents. The Help opens in a separate window. In the left-pane, click Using IngresConnect Sample Projects.
• (X100 only) VWLOAD command and COPY VWLOAD statement. For information on populating data in X100 tables, see the chapters, “Loading Data into X100 Tables” and “Updating Data in X100 Tables.”
The INSERT statement and the QBF append mode, as alternatives to the COPY statement, provide the most potential for customized validity checking and appending to more than one table at a time. For more information on these alternatives, see the SQL Reference Guide and the Character-based Querying and Reporting Tools User Guide, respectively.
Last modified date: 01/30/2023