Interested to Buy Any Domain ? << Click Here >> for more details...
Where would you find information about the type of database
authority held by the user?
- 2 Answers
- 5539 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sreesh
The informartion can be obtained from catalog table
SYSIB.SYSDBAUTH.
Following authories are kept on DB level in SYSIB.SYSDBAUTH.
1) CREATETABAUTH
2) CREATETSAUTH
3) DBADMAUTH
4) DBCTRLAUTH
5) DBMAINTAUTH
6) ISPLAYDBAUTH
7) LOADAUTH
8) REORGAUTH
9) RECOVERDBAUTH
10)REPAIRAUTH
11)STARTDBAUTH
12)STATSAUTH
13)STOPAUTH
| Is This Answer Correct ? | 1 Yes | 0 No |
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is the difference between cursor and select statement?
What is a composite index and how does it differ from a multiple index?
What is -904 sql code? How to resolve it?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
i want to delete 20th million record how ?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is cursor with hold option in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
COBOL 
