2

What are some commands related to IBM DB2?

edit

• db2

asked 2023-05-10 23:50:58 +0000

scrum
21 ●2 ●2

edit retag flag offensive close merge delete

add a comment

1

answered 2023-05-11 00:00:02 +0000

lakamha
21 ●3 ●3

1. CONNECT - Establishes a connection with a DB2 database.
2. CREATE TABLE - Creates a new table in a DB2 database.
3. INSERT - Inserts data into a DB2 database table.
4. SELECT - Retrieves data from a DB2 database table.
5. UPDATE - Updates data in a DB2 database table.
6. DELETE - Deletes data from a DB2 database table.
7. GRANT - Grants privileges to users for a DB2 database object.
8. REVOKE - Revokes privileges from users for a DB2 database object.
9. ALTER TABLE - Modifies the structure of a DB2 database table.
10. BACKUP - Backs up a DB2 database.
11. RESTORE - Restores a DB2 database from a backup.
12. RUNSTATS - Updates statistical information about a DB2 database table.
13. EXPORT - Exports data from a DB2 database to an external file.
14. IMPORT - Imports data into a DB2 database from an external file.
15. SET - Changes the value of a DB2 database or system parameter.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss