Troubleshooting Tips for Data Loading
Follow these tips if you have trouble loading your data into the designated tables:
• Try loading two rows from the data file to the table until you succeed. Check the database table to be sure the results are accurate and copy the entire file.
• Use the COPY statement options to continue on error and log records that fail; examine the records later. Details are described in
Control Error Handling with the Copy Statement (see page
Error Handling with the Copy Statement).
If you are not able to load data from binary files:
• Make sure that the data comes from exactly the same machine architecture. Integer and floating point formats can differ between machines.
• Pick apart your data column by column, using dummy formats for the rest of the row until the COPY statement succeeds.
• If all else fails, get an ASCII copy of the data so you can correct errors.