Bopinko's Friends

View All

Bopinko's Discussions

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 on table schema_name.table_name to user.But i receive this…Continue

unique index

Started this discussion. Last reply by Eswar Prasad C Jun 15. 1 Reply 0 Likes

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 ? Or, just to avoid duplicate data in this column?Continue

Unique keys

Started Jun 14 0 Replies 0 Likes

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

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

Started this discussion. Last reply by Michael Hannan Mar 15. 4 Replies 1 Like

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 references primary_key1there is a querySELECT…Continue

View All

Bopinko's Page

Gifts Received

Bopinko has not received any gifts yet

Give Bopinko a Gift

Profile Information

Why join "The World of DB2"?: Looking for "one stop shopping" for information, Looking for education

What information or education would be useful to you?: SQL Writing

Are you a member of IDUG (International DB2 User Group)?: No

Are you a member of a Regional User Group (RUG)? If so, which one?: None

What best describes your job role?: IBM Employee / Business Partner

Comment Wall

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

No comments yet!

Welcome to
The World of DB2

Sign Up
or Sign In

Or sign in with:

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

DB2 Analytics Accelerator

Prerequisites and Maintenance for IBM Db2 Analytics Accelerator for z/OS, V7.1

More…

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 0 Likes

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