How we create a tables in db2,what is the process/syntax to
create a table with example plz?
Answer Posted / dba
Its very much similar as we sue in other DB
Syntax: CREATE TABLE EMPLOYEE(EMP_ID CHAR(10), NAME VARCHAR(20))
The syntax is usful only in command center
But from GUI its more easier to create table
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
What is ibm db2 database?
What is plan in cobol db2?
What is db2 catalog database?
What is bind in db2?
Can there be more than one cursor open for any program?
What is scrollable cursor in db2?
How can deadlocks be resolved?
Give the name of some fields form sqlca.
What is the difference between using bind () and rebind () methods of naming class?
Highlight all the advantages that are attached to a package.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is temporal table in db2?
What is cursor with hold option in db2?
Is db2 a mainframe?