SELECT COLNAME FROM syscat.COLUMNS WHERE tabschema='my_schema_name' AND tabname='my_table_name' AND KEYSEQ=1 See also: How to get primary key of a table from PostgreSQL How to get primary key of a table from SQLite How to get primary key of a table from MySQL How to get primary key of a table ... Read more
Tag Archives: DB2
About DB2 error “CLI0106E Connection is closed. SQLSTATE=08003”
Sometimes, you meet this error “”CLI0106E Connection is closed. SQLSTATE=08003” when you run DB2 tools. This error would be due to “The connection specified by the connection handle is no longer active.” You can add the following to your db2cli.ini file and restart the ... Read more
Withdata Software Released DB2LobEditor Version 1.9
Withdata software has announced db2lobeditor 1.9, a tool that helps you edit DB2 lob (blob, clob) data directly. Version 1.9 Add “Create sub folders by field name”. Add “turning off log” in command line. DB2LobEditor – Edit DB2 LOB data directly DB2LobEditor is ... Read more
Withdata Software Released DB2ToExcel Version 2.1
Withdata software has announced db2toexcel 2.1, a data conversion tool that export DB2 data to excel. Version 2.1 Add “turning off log” in command line. Withdata DB2ToExcel – Tool for exporting DB2 data to Excel Withdata DB2ToExcel is convenient: 1. Easy visually config, just ... Read more
Withdata Software Released DB2ToTxt Version 2.1
Withdata software has announced db2totxt 2.1, a data conversion tool that export DB2 data to flat file (csv, tsv, xml, html, sql) and excel. Version 2.1 Add “turning off log” in command line. Add an option for “replace CRLF with space”. DB2ToTxt – The better tool to ... Read more
Withdata Software Released XlsToDB2 Version 2.0
Withdata software has announced xlstodb2 2.0, a data conversion tool that import Excel data to DB2 database. Version 2.0 Add “turning off log” in command line. Add “Bad File” to log failed import records. Fix bug “falied load part columns data in command ... Read more
Withdata Software Released TxtToDB2 Version 2.0
Withdata software has announced txttodb2 2.0, a data conversion tool that import txt (csv, tsv) data to DB2 database. Version 2.0 Add “Bad File” to log failed import records. Add “Exception Report From”. Improve import performance. TxtToDB2 – Better tool to import ... Read more
About “Cannot load client library: db2cli.dll”
When you use DB2 tools that call DB2 client library “db2cli.dll”, you may meet this error: “Cannot load client library: db2cli.dll” You can download this tool to solve the problem: DB2_CLI_Setup_32.zip ... Read more
About “Cannot load client library: db2cli64.dll”
When you use DB2 tools that call DB2 client library “db2cli64.dll”, you may meet this error: “Cannot load client library: db2cli64.dll” You can download this tool to solve the problem: DB2_CLI_Setup_64.zip ... Read more
Withdata Software Released SqliteToDB2 Version 1.0
Withdata software has announced sqlitetodb2 1.0, a data conversion tool that convert SQLite data to DB2 database. Version 1.0 is the first release. SqliteToDB2 – Convert SQLite data to DB2 SqliteToDB2 is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress, ... Read more