Stack Overflow
Stack Overflow

Questions tagged [db2-11]

DB2 is a family of database servers developed by IBM.

DB2 is a family of database servers developed by IBM. Supported platforms for DB2 servers are z/OS (formerly OS/390), Linux, UNIX, and Windows.

Version 11 of DB2 includes performance improvements, higher support for SQL, XML, and temporal tables, security compliance, and availability enhancements.

6 questions
3
votes
1 answer

DB2 11.1 - Unpivot table and choose value based on condition

I'm working in DB2 v11.1 I have a table in the following format: CREATE TABLE SCHEMA.TEST_TABLE ( NAME VARCHAR(5) ,RATING VARCHAR(4) ,AAA_X INTEGER ,AAA_Y INTEGER ,BBB_X INTEGER ,BBB_Y INTEGER ,CCC_X INTEGER ,CCC_Y INTEGER ,DDD_X INTEGER ,DDD_Y…
not Steve
  • 81
  • 5
1
vote
0 answers

Commenting on SQL Routines in Modules

Is it possible to comment on routines within modules in DB2 11.5 LUW? CREATE MODULE Documentation says "COMMENT on objects in the module" is something that can be done with an ALTER MODULE (along with ADD/PUBLISH/DROP). ALTER MODULE Documentation…
Dylan Bramblett
  • 133
  • 1
  • 1
  • 6
0
votes
1 answer

Strange numbers in db2top

I occasionally use db2top to get a quick overview of what is happening. I think I've seen it before but not reflected over it, but today I noticed that there are some strange numbers in the Tables view. As an example for a certain table: Delta…
Lennart - Slava Ukraini
  • 6,936
  • 1
  • 20
  • 32
0
votes
2 answers

Higher precision on current_timestamp?

More of an amusement than a real problem, but is it possible to get higher precision than microsecond in current_timestamp. Syntactically: values current_timestamp(12) works fine, but the last 6 digits always seems to be 0
Lennart - Slava Ukraini
  • 6,936
  • 1
  • 20
  • 32
0
votes
0 answers

Db2 Nested Query Error SQLCODE=-206, SQLSTATE=42703

WITH EXECUTIONDATES AS ( SELECT MONTHNAME(UBEXECUTIONDT) AS MONTHNAME,UBEXECUTIONDT FROM WASADMIN.UBTB_CLOSEOFFHIST ),CALCULATED_INT AS ( SELECT ED.UBEXECUTIONDT AS "EXECUTION DATE",IH.ACCOUNTID,MIN(IH.CLEAREDBALANCE) AS "MINIMUM…
Serak Shiferaw
  • 993
  • 2
  • 11
  • 32
-1
votes
1 answer

Unable to create tables in DB2 11.1 installed on Linux VM

I am trying to create a 'employee' table in DB2 11.1.4.6. However getting -bash: syntax error near unexpected token `(' Installed Db2 11.1 on Linux. Also created 'professional' schema. Below is the error :- [db2inst3@DB2101 ~]$ db2 create table…
Vishwanath Mayya
  • 17
  • 1