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
Tag Archives: DB2
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
Edit DB2 LOB data
Db2lobeditor is a database tool that can edit DB2 lob data directly. Use DB2LobEditor, you can edit DB2 LOB visually. And you can save LOB data to file and edit also. Easy to use Edit LOB (LOB, CLOB) data directly. Edit multiple formats LOB data(text, RTF, image, hex, html, xml…). Save ... Read more
How to Install and Configure DB2 ODBC Driver
1 Download and Install Download DB2 CLI ODBC Driver: for x86 ... Read more
Bulk/Batch Export DB2 All Tables
Want to bulk export DB2 all tables? Using DBToFile, a native GUI tool, you can export data from DB2 tables to TXT, CSV, TSV, SQL, XML, JSON, HTML, and Excel, easily and fast. Step by step, just a few mouse clicks. Support schedule and automate converting task. Download DBToFile ... Read more