{"title":"\u3010Db2\u3011\u7279\u5b9a\u30c6\u30fc\u30d6\u30eb\u306eExport/Import\u30cf\u30f3\u30ba\u30aa\u30f3","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.mtioutput.com%2Fentry%2Fdb2-export-import\" title=\"\u3010Db2\u3011\u7279\u5b9a\u30c6\u30fc\u30d6\u30eb\u306eExport/Import\u30cf\u30f3\u30ba\u30aa\u30f3 - (O+P)ut\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","blog_url":"https://www.mtioutput.com/","provider_name":"Hatena Blog","categories":["Database","Database-db2"],"width":"100%","height":"190","published":"2020-06-10 00:00:00","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/m/mtiit/20190220/20190220103611.jpg","version":"1.0","author_url":"https://blog.hatena.ne.jp/mtiit/","provider_url":"https://hatena.blog","blog_title":"(O+P)ut","url":"https://www.mtioutput.com/entry/db2-export-import","author_name":"mtiit","description":"\u306f\u3058\u3081\u306b \u7aef\u672b\u306b\u7528\u610f\u3057\u305fDb2\u74b0\u5883\u3092\u5229\u7528\u3057\u3066 Export\u30b3\u30de\u30f3\u30c9\uff06Import\u30b3\u30de\u30f3\u30c9\u306e\u8a66\u3057\u6253\u3061\u3092\u3057\u305f\u969b\u306e\u30ed\u30b0\u3067\u3059\u3002 \u74b0\u5883\u60c5\u5831 DB2 v11.5 CentOS Linux 7 (Core) \u30c6\u30fc\u30d6\u30eb\u79fb\u884c\u306e\u30cf\u30f3\u30ba\u30aa\u30f3 \u4ee5\u4e0b\u8a18\u4e8b\u3067\u4f5c\u6210\u3057\u305fSAMPLE\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306eSALES\u30c6\u30fc\u30d6\u30eb\u3092\u5bfe\u8c61\u306b\u884c\u3044\u307e\u3059\u3002 \u73fe\u72b6\u306e\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u78ba\u8a8d $ db2 'select count(*) from sales' 1 ----------- 131589 1 record(s) selected. CSV\u5f62\u5f0f\u3067\u51fa\u529b\u3059\u308b $ db2 \"export to /tmp/testdb.csv of del select *\u2026"}