On the IBM i when using the CPYFRMIMPF how should I create the ERRRCDFILE
I want to use the ERRRCDFILE parameter on the CPYFRMIMPF but Google hasn't been able to help me find …
![]()
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.8K 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
Article
Recursive SQL in DB2 (Converting rows to columns)
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence)
A …
A …
Troubleshooting Solution
DB2 Alter Column
Running DB2 10.5 on Windows server
I am trying to add a default to a column on a large table and …
I am trying to add a default to a column on a large table and …
Troubleshooting Solution
Synchronize / link two databases -- MySQL and IBM AS400 / ISeries DB2
I am looking to synchronize / link two databases.
The one being AS400 DB2 – the other MySQL.
Have …
The one being AS400 DB2 – the other MySQL.
Have …
Troubleshooting Solution
stored procedure with multiple functionality for dropping and creating indexes
Hi there,
Can any let me know if it is possible to have procedure with below functionality?
The …
Can any let me know if it is possible to have procedure with below functionality?
The …
Troubleshooting Solution
DB2 10.5 to 11.5 Upgrade
We are currently running DB2 LUW 10.5 on Windows server and need to upgrade to 11.5. Does anyone …
Troubleshooting Solution
What are the best freeware alternatives to Erwin Data Modeler
I will like to get the data structure of an exisiting database. In particular I will like to view …
Troubleshooting Solution
How to know the last time tables in a schema had a DML operation from DB2
I will like to know the last time tables in a schema had a select, insert or delete operations in a
…
Troubleshooting Solution
Linux ODBC Connection using IBM AS400 Client Solutions on Raspberry pI
QuickStartGuide.html
I currently have an application that uploads production data from a Raspberry Pi …
I currently have an application that uploads production data from a Raspberry Pi …
Troubleshooting Solution
How to use SQL to substract 2 months from BD2 data number 1200228
HI
I have a AS400 BD2 data field representing a date - the format is yyymmdd, but the data type is …
I have a AS400 BD2 data field representing a date - the format is yyymmdd, but the data type is …
Troubleshooting Solution
DB2 10.5 Backup permission
I am running backups on my DB2 10.5 instance running on Windows using CommVault. When I run the …
Research Solution
Dynamic SQL
Hi Experts,
How can I get the result from an SQL select into result table
The situation that makes …
How can I get the result from an SQL select into result table
The situation that makes …
Troubleshooting Solution
list of values not picked in the In clause
Hi,
We are on Postgresql 9.6 version.
I have a SQL statement which has a number of names in the IN …
We are on Postgresql 9.6 version.
I have a SQL statement which has a number of names in the IN …
Troubleshooting Solution
DB2: Getting MAX date for multiple columns
How do you find the MAX of multiple date columns for DB2? I've done it in SQL using code similiar …
Troubleshooting Solution
DB2 Restore to new server
DB2 10.5 on Windows
This is a follow up to my last question about moving database to a new server…
This is a follow up to my last question about moving database to a new server…
Troubleshooting Solution
QZDASOINIT jobs running at priority 20, but should be 50 according to JOBD, SBSD, RTGE, and CLASS
Hello,
I cannot figure out what is wrong. QZDASOINIT jobs are running at priority 20, but should be …
I cannot figure out what is wrong. QZDASOINIT jobs are running at priority 20, but should be …
Troubleshooting Solution
DB2 - Error on IN clause in subselect
Experts,
I am struggling with a simple DB2 query.
I am using a subquery to return records where either …
I am struggling with a simple DB2 query.
I am using a subquery to return records where either …
Troubleshooting Solution
Windows Connect to Mainframe via ODBC
I am attempting to connect my PHP web server (Apache) (Windows Server 2019) to our Mainframe via …
Troubleshooting Solution
An INSERT statement with SELECT in DB2 and SQL Server
I have a table ITEMS with the following columns:
ID DESCRIPTION
23 ABC
24 DEF
I will like …
ID DESCRIPTION
23 ABC
24 DEF
I will like …
Troubleshooting Solution
Crosstab query for QMF/DB2
Hello. I am trying to create a crosstab query in QMF/DB2. I know that there is no Transform function…
Explore solutions and more
IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.