DB2 - create table throws syntax error "(" unexpected

Question

When I try to create table in db2, it throws the following error

$ db2 CREATE TABLE employee(emp_id INT NOT NULL, emp_name VARCHAR(100))
sh: Syntax error: "(" unexpected

Please help. Thanks in advance

Answer 1

The problem is not DB2 but the shell. Use:

$ db2 "CREATE TABLE employee(emp_id INT NOT NULL, emp_name VARCHAR(100))"