Explore DB2 on Experts Exchange

Expert Solutions for Your Tech Problems

DB2

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-r...

Read more
  • 5.9K Content
  • 1.2K Contributors

Expert Spotlight
Database Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Troubleshooting Solution

DB2 SQL - find uptime values in a table

163
Hi all,

I have hundreds of identical tables - one for every hour:
        I_YEAR INTEGER NOT …
Article

Recursive SQL in DB2 (Converting rows to columns)

4
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence)


A …
Article

Recursive SQL in DB2 (Converting Columns to Rows)

2
Recursive SQL in UDB/LUW (it really isn't that hard to do)

Recursive SQL is most often …
Troubleshooting Solution

Using DB2 Temp Tables

3

Running DB2 11.5 LUW on Windows Server.


I am trying to use temp table in DB2 11.5 and not having much

Article

Setting the Session Date Format in DB2 UDB for AS/400 / iSeries / System i

2
November 2009

Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB …
Troubleshooting Solution

stored procedure with multiple functionality for dropping and creating indexes

74
Hi there,
Can any let me know if it is possible to have procedure with below functionality?
The …
Troubleshooting Solution

need help with select statement

58
Hi all,

I have this table:

CREATE TABLE DBO.PositionRecord_type (
      I_YEAR INT NOT NULL,
      …
Troubleshooting Solution

MY FILTER DOES NOT RETURN DATA ROWS, YES THE ROWS EXIST, WHAT'S UP?

55
THE SPROC BELOW RETURNS NO ROWS AFTER I ADD THE TERMDATEC FILTER IN THE WHERE STATEMENT. WHAT IS THE…
Troubleshooting Solution

IBM DB/2 ODBC connection error after system swap

6

Hello Experts,


I am an ODBC dummy and have been pulled into a problem with an ODBC connection to a

Troubleshooting Solution

Crosstab query for QMF/DB2

56
Hello. I am trying to create a crosstab query in QMF/DB2. I know that there is no Transform function…
Troubleshooting Solution

Another SQL with parm Part 2

44
Ok this is great all the advice was noted and the procedure ran great for one Plant.  That was the …
Troubleshooting Solution

Date-time primary key in DB2

38
Hi all,

I have a table defined as follows:

CREATE TABLE table (
      DT_WHEN TIMESTAMP DEFAULT …
Troubleshooting Solution

SQL CF and DB2 date syntax error (or value of date)

39
having trouble with CF, SQL, and AS400 DB2. The current code is;

<cfparam type="date" …
Troubleshooting Solution

query help, again

40
This is going to be a bit tricky but I am hoping for an easy answer :).  I asked a question earlier …
Troubleshooting Solution

SQL with subquery

39
I have the following tables:
Table:  CJOBDR
Fields:
edjob# - relates to CJOBH.dnjob
edseq# - …
Troubleshooting Solution

replication of DB2 to MS SQL

43
Dear all,

right now one old DB2 is getting old but we do not have DB2 DR site in case the old …
Troubleshooting Solution

running cl command from java

40
i have to execute cpytoimpf command from my java code ...can some1 tell me how to do that from …
Troubleshooting Solution

DB2: select max() base on a time interval

31
Hi all,

I have a table with the following columns:

[i_year] [int] NOT NULL,
      [i_month] [int] …
Troubleshooting Solution

Time Diffrence in DB2

bySenz79
37
Hi
I am attaching the query i need to modify the query at the WHERE clause and get all the data …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more