The World of DB2
IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Bopinko's Discussions
I can not ake a grant statement
Started Jul 10, 2018 0 Replies 0 Likes
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, 2018. 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, 2018 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, 2018. 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
Gifts Received
Bopinko has not received any gifts yet
Bopinko's Page
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
Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.
Forum
Change tracking on DB2 version 11.0 on Z/os
Started by Rakesh in Application Development and DB2 on Thursday. 0 Replies 0 Likes
Hi All,I am from the solution team, we have a requirement to track the changes(UPDATE & INSERT) in a particular column from different tables. Can this be achieved on DB2 Z/os ?? If yes, please advise.I have been exploring triggers on DB2 but…Continue
Creating a function in DB2
Started by Jacob Ruchotzke in What's hot ? Jun 18. 0 Replies 0 Likes
With the help of our IT guy i have sort of gotten an example of how to create a function in our system. Can anyone help me with this? Please see the attached SQL file.Thanks in advanceContinue
Tags: function
Groups
Db2 NIghtShow
IBM Big Data & Analytics Hub
PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]
© 2020 Created by Surekha Parekh.
Powered by
Comment Wall
You need to be a member of The World of DB2 to add comments!
Join The World of DB2