Want to parse RDF file and save to DB2 ? Want to schedule and automate this importing task? To import Xml format RDF file (.rdf, .owl) to DB2, https://www.withdata.com/blog/rdftodb2/db2-import-rdf.html To import RDF Turtle file (.ttl, .n3) to DB2, ... Read more
Tag Archives: DB2
How to select N random records from a DB2 table
If you want to select N random records from a DB2 table, you need to change the clause as follows: select * from tableName order by rand() fetch first N rows only For example, to select 5 random customers in the customers table, you use the following query: select * from customers order by rand() ... Read more
How to get index column names of a table from DB2
select name,colnames from sysibm.sysindexes where tbname='my_table_name' See also: How to get index column names of a table from SQL Server How to get index column names of a table from MySQL How to get index column names of a table from PostgreSQL How to get index column names of a table from ... Read more
How to get primary key of a table from DB2
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
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