User Profile

manjuns · Sep 16 '09, 02:58 PM

Hi,

Any body knows list of ALTER commands which needs REORG command needs tobe issued.

As per I know is ALTER Table.. Drop Column

regards,
Manju

manjuns · Apr 15 '09, 07:24 AM

Hi,

I am trying to update column(col1) which is of type varchar with below SQL, I am getting com.ibm.db2.jcc .b.nm: DB2 SQL Error: SQLCODE=-408, SQLSTATE=42821.

Same sql is working well with Oracle and Postgres, so does that mean DB2 auto conversion from integer to varchar is not supported??

update tabA set col1=0 where ...

manjuns · Mar 31 '09, 03:40 PM

create table A(a1 varchar(10))
create table B(b1 varchar(10), a1 varchar(10) not null)

alter table A add primary key(a1)
alter table B ADD CONSTRAINT "a_fkey" foreign key (a1) references A (a1) on delete cascade

insert into A(A1) values('a1')
INSERT INTO B (b1, A1) VALUES ('b2','a1')

delete from A

I don't see corresponding rows deleted from Table B.
...

manjuns · Mar 3 '09, 03:02 PM

I have two tables
Table A with columns name, eid
Table B with columns text, eida

select name, eid tableA where eid=1

union

select name, eida tableB where eida=1

due to difference in the name of column(eid and eida). Our Web based Application is having lot complex query
which is working fine with Oracle and without making any modification to SQL, is there any way to fix...

User Profile

Profile Sidebar

List of ALTER Commands which needs REORG to be issued

DB2 integer to Varchar autoconversion in Update

DB2 on delete cascade is not working

DB2 Join result columns are unnamed due to different column names used in subqueries