<div>
Pawan, is there something specific to DB2?
</div>


Pawan, is there something specific to DB2?

<div>
No. but can get the idea from these and create your own. Since SQL server and Oracle more used that why we get more stuff on these. :)
</div>


No. but can get the idea from these and create your own. Since SQL server and Oracle more used that why we get more stuff on these. :)

<div>
<div class="content wysiwyg-content">
I have been asked to generate Reports from lots of tables in DB2.<br />
<br />
I want to learn to solve writing queries from simple to complex through lots of problems and suggested the solution.
</div>
</div>


I have been asked to generate Reports from lots of tables in DB2.

I want to learn to solve writing queries from simple to complex through lots of problems and suggested the solution.

DB2 SQL Query Tricks for Reports

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.