DB2 Commonly Used Fool Questions 1000 Questions (IV) Page 2/2

What are the permissions?
CONTROL permissions: If the user creates an object, the user can fully access the object.
The GRANT statement grants permissions to the user.
The REVOKE statement revokes a user's permission.

What are there?
CREATE
DECLARE
ALTER
DROP
wait
What are there?
INSERT
SELECT
UPDATE
DELETE
wait

118. Is there a Boolean type in DB2?
No

119. How to query DB2's built-in functions?
In-house document ADMINISTION-->SQLREFERENCE-->FUNCTIONS

120. How to execute DB2 script files?
DB2-VTFFILENAME

121.What is the ROWNUM() of ORACLE in DB2?
ROW_NUMBER()OVER()

122. How to get the description of the error code in DB2?
DB2?SQLCODE

123. Is the function of converting VARCHAR to INTEGER in DB2 as?
CAST()

124. What is the function of converting INTEGER into VARCHAR in DB2?
CHAR()

125. Is the function of converting VARCHAR to DATE in DB2?
DATE()

126. Is the function of converting DATE into VARCHAR in DB2?
CHAR()

127. Can TRIGGER in DB2 be modified?
No, only rebuild can be deleted

How to know the port number of DB2?
\WINNT\SYSTEM32\DRIVERS\ETC\SERVICES

129.How to execute stored procedures in DB2?
Can DB2CALLPROCEDURE_NAME

130. How to enter the DOS command method of DB2?
DB2CMD

131. How to get the process number of DB2?
DB2LISTAPPLICATIONS

132. How to kill the DB2 process?
FORCEAPPLICATION(ID)

After the user installs DB2, how to start DATABASE with user B?
Add in .PROFILE under B user
./HOME/DB2INST/SQLLIB/DB2PROFILE

134. What is the snapshot similar to ORACLE in DB2?