5. Populating Tables : Fastload Operation : Perform a Fastload Operation
 
Share this page                  
Perform a Fastload Operation
To perform a fastload operation (load binary format files into a table), perform the following steps:
1. Back up the content of the table.
You need a backup because it can be difficult to fix or eradicate loaded data that is incorrect.
Always check manually that the data has been loaded correctly.
2. Generate a copy of the file you want to fastload by copying it from an Ingres table that has the same format as the target table, or by creating it programmatically.
Use an unformatted copy. For example:
COPY test() INTO 'test.out'
3. Enter the fastload command. For example:
fastload fload -file=test.out -table=test
The table “test” in the database “fload” is loaded from the file “test.out”.
4. Observe that a summary of the load displays the row size, number of rows loaded, and the number of bytes read.
5. Verify manually that the data has been loaded correctly.