Structured Query Language aka SQL is the industry standard to talk to Relation database management systems (RDBMS). RDBMS and SQL are like an alias to each other. To perform any action on RDBMS you need SQL.

All the basic concepts of SQL are the same for every RDBMS like SQLServer, DB2, MYSQL, Oracle, etc. But every database provides some special SQL, specifically for that database. Here will talk only for DB2/400.

Let’s Get to Point.

SQL statements are categorized as follows:

  1. Data Control Language (DCL) statements: To…