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
Tag Archives: DB2
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
Withdata Software Released DB2ToTxt Version 1.9
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
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