How to execute query "select * from Emp where emp_id=2" in DB2

[swapnali143]

How to execute query "select * from Emp where emp_id=2" in DB2

[Anas Mosaad]

First, you need to open db2cmd for windows or switch to the instance owner in *inux platforms.
Second, connect to the database.
Third, issue the command

db2 "select * from Emp where emp_id=2"

If you have data studio or in earlier releases Control Center, you can execute the command from the command editor.