August 16, 2006 at 2:14 am
how to make tables in DB2 ?
i dont find any graphical wizard in DB2 like MS SQL erver for table creation
August 16, 2006 at 11:54 am
Try a DB2 discussion forum like http://www.dbforums.com/f8 or http://www-128.ibm.com/developerworks/forums/db2_forums.jsp
I'll bet you'll get more responses.
Good luck!
Greg
Greg
August 17, 2006 at 7:00 am
You can use straight ddl to create the table syntax is a little different.
Create table qgpl.mytable (col1 varchar(20), col2 decimal(5,0))
You can run this multiple ways, third party sql tool, runsqlstm at the green screen.
Tom
August 17, 2006 at 1:40 pm
Enjoy yourself in the past ... however you should explore the DB2 Command Center (a little like QA) and the DB2 Control Center (a little like EM). The advice given about selecting different discussion groups is very good advice too. Also, get used to scripting no matter what DBMS you are using.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 18, 2006 at 9:23 am
You can user iSeries Tools like (iSeries navigator) it is similar to EM in SQL. This is windows based not green screen. You create tables, Stored procedures and more.
SM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply