DB2

5K

Solutions

3

Articles & Videos

2K

Contributors

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.

Refine results

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 inc…

518 views
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Hi ,
I have data as below

mary
john simpson
L
P
KAMRA

I want result like

L
P

Thanks

415 views

Hi,

 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…

412 views

Table a
Emplid.   Code.  Period
123          744      3
123.         510.     3
123.          744.    4
123.           890.    4
123.           615.    5
123.            510.   5

I want to q…

1631 views

Hi,
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

222 views

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…

661 views

Hi,

 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 Assistant…

325 views

Hi

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 …

748 views

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 .

541 views

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…

4449 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

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.

436 views

Hi Experts,

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 pr…

552 views

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 a…

1048 views

I need to create a store procedure which calls a CL program.
I want the stored procedure to return the output when called.But when i define a stored procedure with input and output parameters im not …

131 views

Hi DB2 gurus,

I am trying to compile a simple score to assist in determining the type of tool I will like to have for my new brand new DB2 environment. I have worked with a few but I do need some a…

296 views

I hear db2 can't snapshot... we just have to live with the fact that during backup some oprations (like changes to tables) might hang.... Is this true?

368 views

Experts,

I am able to query a DB2 table from SAS EG using a connection to DB2.
 I can assign a library using:
LIBNAME TST DB2 USER=&USR. PASSWORD=&PWD. DATASRC=&SRC.;

The problem is the lib is…

154 views

Historically our IBM i Developers have done their own "Database Administration".   We recently got a new manager for our IBM i Development team and they are requesting that our System Administrators t…

673 views

Hi,

  I want to check if a Month-Year falls in a date range.
Example: 10-2014 between 01/01/2014 and 12/31/2014

How can i do this in DB2 UDB SQL?

1575 views
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Dear Techies,
I have to create a table output based on the following conditions.
Three COLUMNS : TX_Vereinbart, DISCOUNTS, IA_Vereinbart
They all are coming from table called EP101T

The below ar…

485 views

Hi,

  Well, this is an Oracle DBA helping an application user that uses DB2.
 
  I am having the below error register in the event viewer of the database server.

  Also when i execute the co…

3771 views

Is there a query to run in DB2 (or a command to run that would accomplish the same thing) that will show me all tables with an owner of "username".

I know in Oracle - we would run the following com…

283 views

Using DB2 on an iSeries I need to create a query that will produce sales results for the week, month, and year in one query. I can create them individually and my code for the week is as follows:

781 views

I am writing a program where the boss wants the calc specs in RPG Free.  I am struggling with what used to be a simple thing but its not so simple for me in Free format .  The input file has a single …

389 views

I am trying to build a DDL statement off a COBOL program layout.  I have never used COBOL syntax before.

I AM NOT SURE WHAT PIC X(26) , PIC XX OR PIC X MEAN?
Example:
Cobol layout
TIMESTAMP     …

3107 views
Show more content
201506-LO-Top-001
Top Experts In
DB2
<
Monthly
>

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Databases
    (53,488)
  2. IBM System i
    (3,526)
  3. Query Syntax
    (47,287)
  4. Operating Systems
    (34,431)
  5. MS SQL Server
    (156,654)
  6. Oracle Database
    (77,856)
  7. Unix OS
    (32,678)
  8. Java
    (98,623)
  9. MS SQL Server 2005
    (71,484)
  10. Mainframe OS
    (453)