Skip to content Skip to sidebar Skip to footer
Showing posts with the label Db2 Luw
Db2 Luw 10.5 - How To Force Db2 Stored Procedures To Use Latest Stats For Most Optimized Plan

Db2 Luw 10.5 - How To Force Db2 Stored Procedures To Use Latest Stats For Most Optimized Plan

Post a Comment
We see an issue occasionally. Stored procedure running a SQL runs very slow. Same SQL when run fro… Read more Db2 Luw 10.5 - How To Force Db2 Stored Procedures To Use Latest Stats For Most Optimized Plan
Db2 Sql Function With Dynamic Return Value

Db2 Sql Function With Dynamic Return Value

Post a Comment
I have the following working DB2 SQL function CREATE OR REPLACE FUNCTION selector (param VARCHAR(3… Read more Db2 Sql Function With Dynamic Return Value
Db2 Size Of Table

Db2 Size Of Table

Post a Comment
I'm trying to figure out the size in kb of each table in a schema. I have a query set up, but I… Read more Db2 Size Of Table
Db2, When Trying To Calculate Difference Between Provided And Stored Timestamp I Get An Error 'the Invocation Of Function Is Ambiquious'

Db2, When Trying To Calculate Difference Between Provided And Stored Timestamp I Get An Error 'the Invocation Of Function Is Ambiquious'

Post a Comment
This is my sql string from which I prepare statement: SELECT (DAYS(?) - DAYS(FROM)) * 86400 + (MIDN… Read more Db2, When Trying To Calculate Difference Between Provided And Stored Timestamp I Get An Error 'the Invocation Of Function Is Ambiquious'
DB2, When Trying To Calculate Difference Between Provided And Stored Timestamp I Get An Error 'The Invocation Of Function Is Ambiquious'

DB2, When Trying To Calculate Difference Between Provided And Stored Timestamp I Get An Error 'The Invocation Of Function Is Ambiquious'

Post a Comment
This is my sql string from which I prepare statement: SELECT (DAYS(?) - DAYS(FROM)) * 86400 + (MIDN… Read more DB2, When Trying To Calculate Difference Between Provided And Stored Timestamp I Get An Error 'The Invocation Of Function Is Ambiquious'