Tagged Questions

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 (referred to collectively as DB2 for LUW), and IBM i (formerly OS/400 or i5/OS). Originally designed as a relational engine, IBM has expanded DB2's ...

I am reading from a table in Oracle and inserting the entire dump into Db2.
The table structures are the same.I am using Simple scala class which does the above mentioned task. I have set the insert ...

We are trying to migrate a set of Oracle PL/SQL's to DB2. We have set the Oracle compatibility vector in the db2 configuration parameters, but we are facing issues in instances where an xml file is ...

I've been trying to make a login page and have run into a problem with pulling information from the database containing User credentials. When running the code I get the following error "Error: DB2 ...

I have a large query which I am trying top optimize. One of the condition which I would like to change is as shown below. i.e I am trying to remove scalar functions.
Current:
DATE( ACTIVITY.CREATED) ...

I have some Stored Procedure in DB2. Some lines of code (INSERT, UPDATE etc). After some operations I have IF condition that opening/not opening CURSOR. For some reason the CURSOR is not opened even ...

I have a application thas sends an xml into my db2 stored procedure
In SQL Server the stored procedure is written like this:
DECLARE @startWithDiagnosisNumbers xml
SELECT @startWithDiagnosisNumbers ...

I'm trying to remove blank spaces that appear in a CHAR column within DB2. I received some helped here with the function TRANSLATE to determine if Left contained records that began with three letters:
...

I am in the process of migrating a VB6 application to VB.Net which connects to DB2 and a Mainframe server. (The application login credentials will be entered in the Mainframe after which the user will ...

I am trying to use a selected field's named alias in a where clause, yet the database complains about being unable to find said field.
Query:
SELECT somefunction(myfield) as mytest, myotherfield as ...

I'm running IBM Data Studio 4.1.1 in Windows 8.1. I have a copy of DB2 Express-C 10.5 on the same machine and it has two instances, the default one of DB2 and a new one I've created called inst2. When ...

I'm running the Hibernate Tools against a DB2 database that permits the same foreign key name to be used in two different tables, each related to the same PK in another table. When the tool attempts ...