Consistency Token & BIND

[stoggers]

Hi,

Is there any way of avoiding rebinds of programs?

In the following scenario:

Program ABC has consistency token 123 and DBRM with consistency token 123 and runs fine against a particular schema where it has been bound as a package.

Program ABC is amended but the SQL statements remain the same, reulting in consistency token 456 and DBRM with consistency token 456.

Can I run the program with consistency token 456 against the schema that was bound with token 123?

Thanks,

Mike.

 

[stoggers]

I have just had a look at the IBM site and it would appear that what I am after is 'DB2 Bind Manager' - does anyone have any experience with this?

Bind Manager replaces DSNHPC (pre-processor) with BNDAVB which performs the same functionality but compares the new DBRM with the old and if they are the same it puts the old consistency token in the generated source, thereby eliminating the need for a REBIND.

Mike.