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年前
関連するコンテンツ
- 質問済み 6年前
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.