*Hello Guyz,*

As per the Manual
+"Plans and packages are not invalidated unless the new column is a TIME, TIMESTAMP, or DATE."+


And I did the following test.

SELECT NAME,COLLID,OWNER,VALID
FROM "SYSIBM".SYSPACKAGE
WHERE NAME='DB2MULSE' ;


NAME COLLID OWNER VALID
DB2MULSE BOBC BOBB Y

The package DB2MULSE is Valid 'Y'.

ALTER TABLE SHANDB.EMPLOYEE
ADD TRIAL DATE
;

The table has been altered.


SELECT NAME,COLLID,OWNER,VALID
FROM "SYSIBM".SYSPACKAGE
WHERE NAME='DB2MULSE' ;


NAME COLLID OWNER VALID
DB2MULSE BOBC BOBB A

As per the manual, the package should have been invalidated.

Am i missing, anything here.

Please let me know you thoughts.

*Thank You,*
Sushanth

For it to be invalidated, it appears that you also need to specify the DEFAULT keyword, and not specify a constant (not use the system default). To validate what I read as being correct, check the bottom of page 71 of V8 Admin Manual. I'm not a DB2 application programmer, thus I'm not 100% confident in this.

*Hi,*

I tried the following query. The check'd the catalogs before & after, Catalog still says package was 'A'ltered.

ALTER TABLE SHANDB.EMPLOYEE
ADD TRY DATE
WITH DEFAULT
'2009-08-26'

;

*Thanks DTSDB2 for your reply & sorry for the late communication,*
Sushanth

It appears that I mistyped. You must not specify a constant associated with the default. Please reference the manual, as I clearly can't read well.