|
View previous topic :: View next topic
|
| Author |
Message |
apvardhini
New User
Joined: 23 Apr 2009
Posts: 20
Location: India
|
|
|
|
Hi All,
We are facing this strange issue. We are in Db2 v10 and are using Native SQl stored procedures. Whenever we Alter a nullable column, all our stored proc packages are getting invalidated. The BIND PACKAGE with DEPLOY option does not help either nor the REBIND command. The Stored procs work only if we drop and recreate them. Can someone help me understand whats happening as the references I have seen says the package should not be invalidated if a nullable column is altered (All alter column is for increasing the size of VARCHAR columns). |
|
| Back to top |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
| Back to top |
|
|
apvardhini
New User
Joined: 23 Apr 2009
Posts: 20
Location: India
|
|
|
|
Yes.. I have, but my scenario is slightly different.
As per redbooks, the packages would also be invalidated when we change the length attribute of a CHAR or VARCHAR column.
So a REBIND should resolve an issue but in my case, only DROP and CREATE works... |
|
| Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
I believe the situation is this.
With a Cobol program, the Package is created when the Bind is done.
The DBRM and Load module come together and the Package is created.
With a Stored Procedure, there is no DBRM or LOAD module. No Bind is performed.
The Package is created with the CREATE statement.
| Quote: |
So a REBIND should resolve an issue but in my case, only DROP and CREATE works...
|
The first part of is statement is not correct. The second part is correct.
Just do the Drop and Create. |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi There,
After rebinding please try stop and start the procedure. |
|
| Back to top |
|
|
|
|
