Withdata software has announced db2tomssql 1.3, a data conversion tool that convert DB2 data to SQL Server database. Version 1.3 add “Task Schedule”, add support to DB2 XML type field, improve importing performance, and fix “division by zero” bug in importing ... Read more
Tag Archives: DB2
Withdata Software Released DB2ToAccess Version 2.2
Withdata software has announced db2toaccess 2.2, a data conversion tool that export DB2 data to access. DB2ToAccess 2.2 add “Task Schedule”, add support to DB2 XML type field, improve importing performance, and fix “division by zero” bug in importing process. DB2ToAccess ... Read more
Withdata Software Released AccessToDB2 Version 2.2
Withdata software has announced accesstodb2 2.2, a data conversion tool that import Access data to db2. AccessToDB2 2.2 add “Task Schedule”, add support to DB2 XML type field, improve importing performance, and fix “division by zero” bug in importing process. AccessToDB2 ... Read more
Withdata Software Released Withdata DB2ToExcel 2.0
Withdata software has announced withdata db2toexcel 2.0, a data conversion tool that export DB2 data to excel. Withdata DB2ToExcel 2.0 add “Task Schedule”, add support to XML type field, improve export performance, and fix “division by zero” bug in importing ... Read more
Withdata Software Released DB2ToTxt Version 2.0
Withdata software has announced db2totxt 2.0, a data conversion tool that export DB2 data to flat file (csv, xml, html, sql) and excel. DB2ToTxt 2.0 add “Task Schedule”, add support to XML type field, improve export performance, and fix “division by zero” bug in importing ... Read more
Withdata Software Released XlsToDB2 Version 1.9
Withdata software has announced xlstodb2 1.9, a data conversion tool that import Excel data to DB2 database. XlsToDB2 1.9 add “Task Schedule”, add support to XML type field, improve import performance, and fix “division by zero” bug in importing process. XlsToDB2 – A ... Read more
Withdata Software Released TxtToDB2 Version 1.9
Withdata software has announced txttodb2 1.9, a data conversion tool that import csv(txt) data to DB2 database. TxtToDB2 1.9 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. TxtToDB2 – A Better Way to import ... Read more
The DB2 equivalent for the MySQL Limit
In MySQL, you can use “Limit n,m”, like this: select * from sometable order by name limit 20,10 And in DB2, use this query: SELECT * FROM (SELECT * FROM sometable ORDER BY name DESC fetch first {start} rows only ) AS mini ORDER BY mini.name ASC fetch first {total} rows ... Read more
Withdata Software Released DB2LobEditor 1.7
Withdata software has announced db2lobeditor 1.7, a tool that helps you edit DB2 lob (blob, clob) data directly. DB2LobEditor 1.7 add PDF View, add “Execute Sql from Command line”, improve logon form, improve “Check update”, and fix bug on “Execute from command ... Read more
Withdata Software Released Withdata DB2ToExcel 1.9
Withdata software has announced withdata db2toexcel 1.9, a data conversion tool that export DB2 data to excel. Withdata DB2ToExcel 1.9 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. Withdata DB2ToExcel ... Read more