Hello:

I have some question on DB2 SQL Statement Cache. In the Oracle world,
we allways use bind variables extensively, otherwise, Oracle does not
re-use the statement cache, and there by resulting in excessive parsing
of the SQL Statements.

In DB2, I have a situation where I have statements with different cast
lengths:

For example, here are my statements:

select * from foo where col1 = cast(:q01 as varchar(40))

and then later execute the same statement with a different casted
varchar length:

select * from foo where col1 = cast(:q01 as varchar(100))

Will the SQL statement be reused from DB2 SQL statement cache?

Does the SQL statement have to exactly match in order for the SQL
statement to be re-used?

I woud like to know the rules of the game in DB2.

Your feedback is appreciated.

Thanks
Sarvesh