1.新建连接create new database connection

  2.database Url:  jdbc:informix-sqli://119.84.39.35:29999/gps_prod:informixserver=ctfgps;DB_LOCALE=en_us.819;CLIENT_LOCALE=en_us.57372;NEWCODESET=GBK,8859-1,819;IFX_USE_STRENC=true;

  3.连接成功!

 

 

RENAME COLUMN sm_user_district.fmms_district_id TO district_id;//已有表修改字段

alter table sm_user_district add district_name VARCHAR(150);// 已有表中新增字段

delete from gps_prod:bm_clog_manage where id=1762;//删除数据