1 回答
- 最新
- 投票最多
- 评论最多
1
You will get an error if the table has more/fewer number of columns than the flat-file when using COPY command. If source file has fewer columns than the target table, add the keyword FILLRECORD to your copy statement to fill the additional columns in target table with NULL and load the data
已回答 1 年前
Thanks @Anusha What is expected to happen in the other way? That is, when there are less columns in the table and more in the file? I am not getting error in that scenario. Please explain.
For flat files, you would get an error when there are extra fields. You can create those extra fields in the table to load the data.
Exactly! I should get an error here there are extra fields in the file. But I am not getting the error. Is there any parameter to set/unset? I would like to get an error when there are extra fields in the file.