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
Make ROWSET cursors available on the Db2 Server and Client.
assistance with multirow fetch A single FETCH statement can be used to fetch several rows with the Db2 Precompiler and embedded Runtime. Arrays can be given as host variables (and as their indicators) in Db2 ESQL, and when ESQL executes the FETCH statements as their output arguments (bind-outs) from the COBOL application, arrays can be used as their indicators. The Db2 Precompiler supports the "For n ROWS" clause in the FETCH statement to pass the cardinality for the array FETCH statement. The variable "n" in the "For n ROWS" clause can be a short data type, a host variable specified as an integer, or an integer in the range of 2 to 32767. The Db2 precompiler for COBOL determines the cardinality of the array size depending on the declared size of host variables used in the SQL if the "For n ROWS" clause is not supplied. If the host variables being utilized are of varying sizes, the cardinality of the bulk or array is determined by the minimum size of all the host variables. Users can look at sqlca.sqlerrd(3), which shows how many records were fetched. run 3
Do not place IBM confidential, company confidential, or personal information into any field.