开发者

Informix: How to truncate a table when importing a dbexport

开发者 https://www.devze.com 2023-02-07 11:07 出处:网络
Is there any 开发者_如何转开发good way to truncate the data of a table when importing a dbexport. I realize that I need to amend the number of rows in the .sql file, but how do I need to amend the unl

Is there any 开发者_如何转开发good way to truncate the data of a table when importing a dbexport. I realize that I need to amend the number of rows in the .sql file, but how do I need to amend the unload file?


If you really just want to load zero rows for the table, then copy /dev/null over the original data file. I haven't checked whether dbimport actually goes out to look for the data file when the SQL file says "0 rows to load", but it might well do so, load what it finds, and report the discrepancy. If the SQL file says "0 rows" and the data file contains 0 rows, then it shouldn't complain.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号