DB2
zml6308
这个作者很懒,什么都没留下…
展开
-
Explain tables does not exist. Check the explain plan properties for this database connection.
使用DbVisulalizer链接db2,查看执行计划是报错误 Explain tables does not exist. Check the explain plan properties for this database connection.就是执行计划的表不村子,检查执行计划属性。查看连接属性如下只有DB2LUW里面才有Explain Plan属性,所以先调原创 2014-12-08 15:03:06 · 5463 阅读 · 3 评论 -
DB2 单张表 merge语句
merge into CHANNEL_AGENT_PEOPLE_NUMBER_201503 a using (SELECT ? TIME_ID,? CITY_NAME,? NODE_NAME,? NODE_CODE,? PEOPLE_NUMBER, ? VEHICLE_RUNNING_COSTS,? MAIL_TRANSPORT_FEES,? TRAINING_COSTS, ? CONSUMAB原创 2015-04-21 10:23:46 · 1216 阅读 · 0 评论