Database Administrator Guide > Database Administrator Guide > Populating Tables > Successful Use of the COPY Statement > Troubleshooting Tips for Data Loading
Was this helpful?
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. For more information, see 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.
 
Last modified date: 11/09/2022