This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updateson them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Let’s review this scenario. You just implemented a new COBOL program into production. But some users are not getting the data they expected. You finally realize an SQL statement you are running is not returning any rows. You’re sure the statement is using the correct host variables, but the query is getting a +100 SQL return code. The query is good; it must be a problem with Db2. You need a way to verify what host variables are being passed to the query.
This is a key feature of IBM db2 Query Monitor. It will display the SQL statement and the variables being passed to Db2. After you verify the variables, you soon realize your program had changed the variable and query was running with the incorrect value.
QM does a good job of capturing the query and the variables; either from TSO or from the Web Client (CAE).
My suggestion is to take it one step further. Let’s say you have a query with many variables (I’ve seen queries well over 100 and up to 500). Using the TSO interface, you can see the values. See attached file for screen shots...
Number Type Null Length Data
1 VARCHAR N 6 TS5941
2 VARCHAR N 3 EMP
3 CHARACTER N 1 T
This is a very simple example. You can see the 3 host variables flow into the SQL statement….
WHERE BCREATOR = : H AND BNAME = : H AND BTYPE = : H
What if you had 36 variables? You must count each one out to figure out what host variable lines up with the SQL statement. What if you wanted to run the exact query in Spufi or QMF? You need to export the query and manually add each host variable into the predicate. If you have a 100 variables, it would take some time.
Wouldn’t it be nice if you could click a button that builds the SQL statement and includes the host variables? You can export the query and have the complete SQL statement? You can then explain it with the host variables or run it in Spufi or QMF. If you had 36 variables and you needed a specific value for a column, generating the complete SQL statement would show you exactly what field lines up in the predicate. This would be great for both TSO and the Web Client (CAE).
Not only would this be good for SELECT statements, but DML as well:
Do not place IBM confidential, company confidential, or personal information into any field.