I am trying to rename a table in db2 like so rename table schema1.mytable to schema2.mytable but getting the following error message: the name "mytable" has the wrong number of qualifiers.. SQL...

I am using db2 9.5 i have created a column in table which is created successfully but i am not able to update table column and getting following error [Error] Script lines: 1-1 -----------------...

I have a DB2 database (let's call it mydb) that I would like to delete. However, when I do db2 drop db mydb I get back SQL1035N The operation failed because the specified database cannot be con...

I am trying to create a user-defined function that returns a table in DB2. Here is what I have so far. This is a table that I use: CREATE TABLE "CORPDATA"."EMPLOYEE" ( "EMPNO" CHAR(6) NOT NULL, ...

Is there a built in function for comma separated column values in DB2 SQL? Example: If there are columns with an ID and it has 3 rows with the same ID but have three different roles, the data shou...

I need a query which will output a list of dates between two given dates. For example, if my start date is 23/02/2016 and end date is 02/03/2016, I am expecting the following output: Date ---- 23...

I want to know the columns (names) which belong to each unique constraint. I can easily find the constraints and the tables names in syscat.tabconst. However I can't find the columns names.

I am having problem with DB2. I just installed the db2 as a db2admin and with a password. When i try to connect to database it is success full and while running any simple select query it give me f...