Hi All,

i want to write a query for creating a Table say Biodata which has age ,Name,Location,Income and mobile number but do not know how to write a correct query that would run using command line editor ...

i have tried creating example provided on the web,but some or the other i was getting exceptions .

I am looking for a example query for creating a simple table and for that created table ,a simple stored procedure query .

would request your expertise ....

thanks

See Examples at the bottom of this topic.
CREATE TABLE - IBM DB2 9.7 for Linux, UNIX, and Windows
Example 1, Example 2, and Example 3 might be enough in the beginning.