{"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/m/mtiit/20190220/20190220103611.jpg","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.mtioutput.com%2Fentry%2Fdb2-batch-usecase\" title=\"\u3010Db2\u3011SQL\u306b\u304b\u304b\u308b\u6642\u9593\u3092db2batch\u3067\u8a08\u6e2c\u3059\u308b - (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>","version":"1.0","provider_url":"https://hatena.blog","url":"https://www.mtioutput.com/entry/db2-batch-usecase","author_name":"mtiit","width":"100%","height":"190","published":"2023-01-22 13:30:50","description":"\u3084\u308a\u305f\u3044\u3053\u3068 Db2\u74b0\u5883\u3067\u767a\u884c\u3059\u308bSQL\u306e\u51e6\u7406\u6642\u9593\u3092\u78ba\u8a8d\u3059\u308b\u3002 \u74b0\u5883\u60c5\u5831 DB2 v11.5 RHEL 7 \u3084\u308a\u65b9 db2batch\u30b3\u30de\u30f3\u30c9\u3092\u5229\u7528\u3059\u308b\u3002 $ which db2batch ~/sqllib/bin/db2batchSQL\u5206\u3092\u8a18\u8f09\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u7528\u610f\u3057\u305f\u4e0a\u3067 select * from sales; \u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5f15\u6570\u306b\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u60c5\u5831\u3092\u5165\u529b\u3059\u308b\u3068 $ db2batch -d XX -a DB2INST1/XX -f test.sql -i complete -o f -1 p 1 o 5\u4ee5\u4e0b\u306e\u3088\u3046\u306bSQL\u306e\u5b9f\u884c\u7d50\u679c\u53ca\u3073\u8a08\u6e2c\u7d50\u679c\u304c\u51fa\u529b\u3055\u308c\u308b\u3002 * 2176 row(s) f\u2026","provider_name":"Hatena Blog","blog_title":"(O+P)ut","categories":["Database","Database-db2"],"author_url":"https://blog.hatena.ne.jp/mtiit/","type":"rich","title":"\u3010Db2\u3011SQL\u306b\u304b\u304b\u308b\u6642\u9593\u3092db2batch\u3067\u8a08\u6e2c\u3059\u308b","blog_url":"https://www.mtioutput.com/"}