How to create a Date Series in DB2

Question: How can I create a Date Series in DB2 LUW. e.g. 01-01-2017 to 30-01-2017 . ? Answer: There are a number of different ways to create a date series in DB2 LUW.One way is the example used below, which lists the dates from 1st January 2017 - 30 January 2017. : db2 "with tempdateseries (date) as ( select date('01.01.2017') as date from sysibm.sysdummy1 union all select date + 1 day from tempdateseries where date < date('30.01.2017') ) select * from tempdateseries" This method will give you an output example such as : 01/01/2017 02/01/2017 03/01/2017 04/01/2017 05/01/2017 06/01/2017 07/01/2017... Read more →

How to check DB2 LUW load status

Question: How can I check load status in DB2 LUW? Answer: Checking the DB2 LUW load status is achieved by using the load query command. The best way to explain is by demonstrating with a simple example. The DB2 LUW command is used to load data into a DB2 LUW table. The data can be stored in many different forms – including named pipe and tape Starting the load process connect to mydb; create table table2 like table1; load from somedata.del of del insert into table2; While the load process is in flight , create another connection and view the... Read more →