Convert sql code to Db2

vega! · #1 (**permalink**) 11-25-10, 08:51

Hi,

Please i need help to convert my Oracle bases in Db2 .
I want one little example , because all the database is the same.

Code SQL:

CREATE TABLE MATRIZAVALIACAORISCORESIDUAL(
ID INTEGER NOT NULL,
TITULO varchar2(750) NULL,
REMOVIDO varchar2(1) NULL,
CONSTRAINT PKMATRIZAVALIACAORISCORESIDUAL PRIMARY KEY (ID)
);

My code DB2

create table dddd
(ID SMALLINT NOT NULL,
TITULO VARCHAR(250),
REMOVIDO VARCHAR(1),
PRIMARY KEY (ID) )

Its works, but don't declare the constraint.
Please, i need to declare this constraint.

Thank you

n_i · #2 (**permalink**) 11-25-10, 10:48

Code:

create table dddd
(ID SMALLINT NOT NULL PRIMARY KEY ,
TITULO VARCHAR(250),
REMOVIDO VARCHAR(1))

vega! · #3 (**permalink**) 11-25-10, 11:12

THKS.. solves the primary key problem , but
I need the name of Primary_Key Constraint to log efects.

Thks

nvk@vhv · #4 (**permalink**) 11-25-10, 11:46

Quote:

Originally Posted by vega!

REMOVIDO VARCHAR(1),

alter table TABNAME add constraint PK_NAME primary key (id)

n_i · #5 (**permalink**) 11-25-10, 12:25

Quote:

Originally Posted by vega!

THKS.. solves the primary key problem , but
I need the name of Primary_Key Constraint to log efects.

Which DB2 version are you working with?

Code:

CREATE TABLE MATRIZAVALIACAORISCORESIDUAL(
ID INTEGER NOT NULL,
TITULO varchar2(750) ,
REMOVIDO varchar2(1) ,
CONSTRAINT PKMATRIZAVALIACAORISCORESIDUAL PRIMARY KEY (ID)
);

The above works for me. You only need to remove the NULL default declarations, because they don't make sense anyway.

It might be a good idea for you to start reading the DB2 manuals. http://publib.boulder.ibm.com/infoce...v9r7/index.jsp

vega! · #6 (**permalink**) 11-25-10, 13:40

Quote:

Originally Posted by n_i

Which DB2 version are you working with?

Code:

CREATE TABLE MATRIZAVALIACAORISCORESIDUAL(
ID INTEGER NOT NULL,
TITULO varchar2(750) ,
REMOVIDO varchar2(1) ,
CONSTRAINT PKMATRIZAVALIACAORISCORESIDUAL PRIMARY KEY (ID)
);

The above works for me. You only need to remove the NULL default declarations, because they don't make sense anyway.

It might be a good idea for you to start reading the DB2 manuals. IBM DB2 9.7 for Linux, UNIX and Windows Information Center

Thks.. solve the problem.
I don't put the codom.
Thanks