Want to upsert data from TXT (“|” pipe delimited text) file to DB2 ? Upsert: inserts rows into a table if they do not already exist, or updates them if they do. Using FileToDB, a native GUI tool, you can upsert data from TXT (“|” pipe delimited text) file to DB2 easily ... Read more
Tag Archives: DB2
Create Excel report from DB2 database
Want to create Excel report from DB2 database? Using DB2ToExcel, you can generate excel report from DB2 easily and fast, no need to program, no need learn VBA, just a few mouse clicks! Here you can download and install DB2ToExcel. Create an Excel report based on DB2 Click “Export From ... Read more
Batch import RTF files into DB2 BLOB without programming
Want to batch import RTF (Rich Text Format) documents into DB2 CLOB or BLOB column? Using DB2LobEditor, you can import bulk rtf files into DB2 CLOB or BLOB easily and fast, just a few mouse clicks. Here you can download and install DB2LobEditor. Batch import RTF documents to DB2 CLOB ... Read more
Some ETL (Extract-Transform-Load) tools for DB2
Withdata Software provide some ETL (Extract-Transform-Load) tools for DB2: FileToDB Load TXT, CSV, TSV, XML, JSON, Excel, SQL, RDF, INI data to DB2 DBToFile Export DB2 data to TXT, CSV, TSV, XML, JSON, Excel, SQL files DBCopier Copy data between DB2 and other rational databases ... Read more
Parse RDF file and save to DB2
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
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
Schedule and automate DB2 exporting to files task
Want to schedule and automate DB2 exporting to files task? Using DB2ToTxt, you can scheduled exporting DB2 data to files task easily, just a few mouse clicks! Here you can download and install DB2ToTxt. Schedule and automate DB2 exporting to files task 1. Select and run a task from follow ... 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