Withdata software has announced db2totxt 1.9, a data conversion tool that export DB2 data to flat file (csv, xml, html, sql) and excel. DB2ToTxt 1.9 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. DB2ToTxt ... Read more
Tag Archives: DB2
Replace (Update/Insert) a row into DB2 table – Merge into
In MySQL, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. How to do it in DB2? Use “merge into” . MERGE INTO table_to_upsert AS tab USING (VALUES ... Read more
Withdata Software Released OracleToDB2 Version 1.2
Withdata software has announced oracletodb2 1.2, a data conversion tool that convert Oracle data to DB2 database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. OracleToDB2 – convert Oracle data to ... Read more
Withdata Software Released MysqlToDB2 Version 1.2
Withdata software has announced mysqltodb2 1.2, a data conversion tool that convert MySQL data to DB2 database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MysqlToDB2 – convert Mysql data to ... Read more
Withdata Software Released MsSqlToDB2 Version 1.2
Withdata software has announced mssqltodb2 1.2, a data conversion tool that convert SQL Server data to DB2 database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MsSqlToDB2 – Convert SQL Server data to ... Read more
Withdata Software Released DB2ToOracle Version 1.2
Withdata software has announced db2tooracle 1.2, a data conversion tool that convert DB2 data to Oracle database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. DB2ToOracle – Convert DB2 data to ... Read more
Withdata Software Released DB2ToMysql Version 1.2
Withdata software has announced db2tomysql 1.2, a data conversion tool that convert DB2 data to MySQL database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. DB2ToMysql – Convert DB2 data to ... Read more
Withdata Software Released DB2ToAccess Version 2.1
Withdata software has announced db2toaccess 2.1, a data conversion tool that export DB2 data to access. DB2ToAccess 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. DB2ToAccess – Better tool for exporting DB2 data to ... Read more
Withdata Software Released AccessToDB2 Version 2.1
Withdata software has announced accesstodb2 2.1, a data conversion tool that import Access data to db2. AccessToDB2 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. AccessToDB2 – Better tool for importing Access data ... Read more
How to get column names from DB2 table
SELECT colname, typename, length, scale, default FROM syscat.columns WHERE tabname = “<table name>” AND tabschema = “<schema name>” See also: How to get column names from Sql Server table How to get column names from Oracle table How to get column names from ... Read more