Articles & Videos
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.
I'm asking this for a co-worker. He has been tasked with migrating data from an IBM AS/400 iSeries DB2 database to a MS SQL 2016 environment. He tried to use the Microsoft SQL Server Migration …
I have two tables join as below giving results as below:
from ps_check a
left outer join ps_earning b
I have a SQLRPGLE program that has to insert thousands of records (possible from multiple instances)
If the file is full (Msg CPA5305) the program will wait until the QSYSOPR message …
I'm trying to make a bash script (oslevel = AIX 7100-04-02-1614) that's going to restore my DB2 database from an existing backup into a different database (DB2PRD3 - DB2PRD4)
below are the …
I have table as below:
emplid effdt date_of_birth
123 2016-01-01 1950-01-01
234 2015-01-01 2000-01-01
result should be:
We need to start using a new tape each night for the backup and keep these tape indefinitely (long story). I would like to have BRMS use the tape without enrolling all the tapes. Can I do …
I'm attempting to use a form instead of InputBoxes to grab the data for the variables in my VBA code. This code opens the form but throws error 424: Object Required. I'm not sure how to call the form …
I have column textcode in many tables I want to find which tables have that column how can i do that.
I am using MS Access as a frontend to a proprietary DB2 database that resides on an iSeries. I have VBA code that I am using to run a QueryDef for a pass-through query and this code prompts the user …
Is there a way to trigger a prompt for input from a user in DB2 SQL? Currently, I am running Pass-Through Queries using Microsoft Access as a front end and on some of my queries I need the flexibility…
I need to query my inventory and select all records for all items where 1 of the records for the item has a last received date older than 20160201. My inventory contains over 11,000 items.
The following query grabs data that I need to pivot but Max and Sum don't play well in the same sentence so to speak. Stubborn Aggregates. I have tried various sub selects but the results come out …
I have data as below
I want result like
I am a a Oracle dba with an issue with a DB2 database system.
The DB2 generates files *.LOG located in a specific drive, and sometimes the drive is running out space.
There are files…
Emplid. Code. Period
123 744 3
123. 510. 3
123. 744. 4
123. 890. 4
123. 615. 5
123. 510. 5
I want to …
I have to filter based upon four columns emplid,empl_rcd,effdate ,seq filter is like 1000 rows in xls.
i can just do select can't create any tables etc.
i am doing
select * from tab
I have a PowerShell script that am using to connect to a DB2 database.
The script has the credentials hard coded at this point, and everything works fine.
I am trying to encrypt the password and…
When in DB2 95, I used to use DB2 Configuration Assistant to create and share the Database profiles and share them with other developers. With DB2 10.1, there is no DB2 Configuration …
I get an error with a SQL statement getting data in a DB2/400 database when the WHERE clause contains a LIKE clause where the content of the LIKE includes the star character, "*", and this in a …
We want to create materialized view in IBM i series v7R1 instead of normal views as we are having performance issue. Could anyone let us know how to create & maintain materialized view .
Ok this is great all the advice was noted and the procedure ran great for one Plant. That was the first test and, then the second test was with a string of plants. The way I constructed the parm was…
I'm looking for a SQL example on how to create one SQL select statement to query across two iSeries with instances of DB2.
Presently, the SQL is being ran interactively from the 5250 Emulator.
While running SQL commands in some own (customer tool) SQLRPGLE, I have the problem that a execute immediate command, exceeds the length of 32700.
If I extend this variable, I get a …
I have 2 tables, tbINVOICE and tbFEE. tbFee contains fees that get populated at the end of an invoice. As a result of a setup error, I have some invoices that are missing a fee that should have been …
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions. It's not alway…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns. A previous article described the process of con…
134 points this week
Sellersburg, Indiana, United States
9 points this week