SYSIBM catalog tables are base tables defined under this schema. There are many schemas defined in DB2. To your quick reading, I have given all the key points here.
Advertisements
Author: Srini
Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.
Explained how to write simple function and execute it in R studio. Given syntax and example explanation.
House keeping you need to do in R Language before closing your session. The popular functions you need to use are search(), objects(), list(), ls(), and detach().
SQL Order of execution is sequence of steps. The database executes each Query in a particular order. Read more.
Data access is much faster in Hashing compared to the index. Read the differences between Hashing and Index.
SQL ALTER statement you can use to add columns to existing TABLE in RDBMS. Not only TABLE you can read all database object where you can use ALTER.
