【项目经验】DB2的插入语句 得带上字段名以及建立虚拟表

DB2的插入语句 得带上字段名

insert into VENDOR (VENDOR_ID, ADD_TIME, TYPE_ID, ORG_ID, CODE, NAME, KIND, REGISTER_CAPITAL, ASSSET_SIZE, MAIN_BUSINESS, BUSINESS_SCOPE, CERTIFICATE, EMPLOYEE_NUMBER, MAIN_CUSTOMER, REGISTER_ADDRESS, WORK_ADDRESS, OFFICE_RIGHTS, CONTACT, CONTACT_CHANNEL, IS_SITE_VISIT, MEMO, STATUS, CANCEL_TIME, CANCEL_MEMO, ORG_IDS, ORG_NAMES, CURRENCY, PINYIN) values(default,"+"'"+data+"'"+","+values.get(i).toString().trim()+") ";

建立虚拟表建立虚拟表

String sql="select t.e_key as key, t.e_value as value  from "
+
"("
+ "select v.NAME as e_key, v.VENDOR_ID as e_value from VENDOR v "
+ " union all(select vt.NAME as e_key, vt.TYPE_ID as e_value from VENDOR_TYPE vt)"
+ " union all(select s.CODEITEM_DESC as e_key, s.CODEITEM_ID as e_value from  SY_CODEITEM s where s.CODESET_ID in('03','06'))"
+ ") t";