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.

Leading Experts In
DB2
<
Monthly
>
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

Table data compression, a multi-valuable database feature.

Data compression is a feature offered by many modern databases like Db2, Oracle, MySQL, MariaDB and SQLServer. However, many companies do not use this feature in their database systems. Either they lack the knowledge of its existence in the application/systems design phase or due to budget issues.
Troubleshooting Solution

DB2 stored procedure using variables and CTE

20

DB2 11.5 on Windows

I am writing a stored procedure where I am using a CTE and setting variables but

Troubleshooting Solution

Delete from DB2 table with many FK constraints

4

DB2 11.5 on Windows


I have a large table that I need to purge of data greater than 10 years old.

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

Why is SQL output in IBM IAccess client displaying in Hex format?

2

Hi.  I am querying IBM DB2 data through the Run SQL Scripts function in the IBM IAccess client. I

Troubleshooting Solution

Insert current timestamp into time stamp column with sql statement

4

How can I insert the current timestamp in to a timestamp column with the insert sql statement?  

I

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

SQL statement generating error due to column too long.

4

I am getting sqlstate 22001, it is a truncation issue on a column when doing an insert.

Can I ask if

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

Determining last 7 dates from current date?  DB2 database.

5

Is there a way to get the last 7 dates from the current date?  So, if today is 20220617. 

I would

Troubleshooting Solution

Cannot activate IBM SPSS Statistics

6

I cannot get IBM SPSS Statistics to activate.

Failed to add license to local license

Troubleshooting Solution

Syntax error in display file

6

Can you please help me with this error? Also how do I get the IPPF prompt on this line?


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

DB2 SQL joining question.

8

Using DB2 SQL, is it possible to join to the same table twice in the same statement using different

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

Postgres - Question about a scenario in error handling

9

Hi, 

  We are on Postgres 13.6 and are in the process of converting some DB2 SPs to Postgres.

As part

Troubleshooting Solution

Screen Design Aid

3

How to center or move text in SDA?


Troubleshooting Solution

DB2 Select where the string contains the underscore character as last character

9

I have a table with a username column.  My testers have created test accounts with various usernames

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more