What's hot ? (57)

Featured Discussions

unique index

Hi guys, if a create unique index on column, which is not primary key, it is make from this column, after put index on it, primary key ? O…

Started by BopinkoLatest Reply

Join the Webcast: Enterprise transformation and innovation - analytic insight at the point of impact

Register for the z Analytics webcast, "Enterprise transformation and innovation - analytic insight at the point of impact  at http://ibm.…

Started by Annette ZawackiLatest Reply

Last Chance to register for Double Webcast Series - Db2 12 with Live Q &A with John Campbell - IBM Db2 Guru

HURRY today is the last chance for you to register our  DOUBLE Webcast Series - Db2 12 Migration Planning and EARLY CUSTOMER EXPERIENCES.…

Started by Surekha ParekhLatest Reply

Discussions Replies Latest Activity

DB2 9.7 database stuck in a backup pending state

I have a DB2 9.7 database stuck in a backup pending state and cannot seem to clear the issue the error is: SQL1116N connection or activati…

Started by Graeme Eagleton

1 on Monday
Reply by Graeme Eagleton

I can not ake a grant statement

Hi, i' ve have this problem: I make an object under schema. And now, with sqlid = schema_name i wnat make grantgrant select, update,delete…

Started by Bopinko

0 Jul 10

New Publication - Building a Spectrum of Capabilities

The Ladder to AI is built with capabilities across 3 platforms: Hybrid Data Management, Unified Governance & Integration, and Data Scie…

Started by Gary Crupi

0 Jul 2

Database objects comparision in DB2

Hello, I'm looking for a DLL that will output the whole difference between two DB2 databases, do you aware of any module that applies this…

Started by Yehuda shmuel

4 Jun 19
Reply by Ember Crooks

unique index

Hi guys, if a create unique index on column, which is not primary key, it is make from this column, after put index on it, primary key ? O…

Started by Bopinko

1 Jun 15
Reply by Eswar Prasad C

Unique keys

Hi guys, it is neccessary to create unique index, before i create table in db2 ?

Started by Bopinko

0 Jun 14

Register for IDUG EMEA Db2 Tech Conference 2018 - Join IDUG's 30th Anniversary Celebrations

Register Now for IDUG Malta 2018 Early Bird Discount Available and join IDUG's 30th Anniversary celebrations !http://bit.ly/IDUGMalta2018 #…

Started by Erwin Hattingh

0 May 27

Excellent Article on Runstats for Db2 - on www.IDUG.org

IDUG has just published an article on how to get the most out of Runstats for the LUW platform, including how to speed up your Runstats. O…

Started by Joe Geller

1 Apr 24
Reply by Surekha Parekh

Books DB2...

Hi Everyone, I'm a rookie in DB2 LUW. And I looking for a good book or manual that you know or you should read that you suggest in order t…

Started by Gerardo Hernandez Sanchez

3 Apr 6
Reply by Kay Groski

Query, which find foreign keys and columns which referencing in DB2 z/OS

Please, can you somebody help me. I need to find a foreign keys and it's parent keys(primary keys) and its name. For example, foreign_key1…

Started by Bopinko

4 Mar 15
Reply by Michael Hannan

RSS

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

Posted by Paul McWilliams on May 22, 2018 at 21:25 0 Comments

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in…

Continue

Videos

  • Add Videos
  • View All

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service