IBM Z Software
Hide about this portal
This portal is to open public enhancement requests against IBM Z Software products. 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 updates on them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Specific links you will want to bookmark for future use
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
Users can configure the Run Options of individual SQL scripts to automatically commit or rollback statements. If you configure a SQL script to "Roll back changes on completion", you will be able to see "how may records will be affected by the execution of the query". The "Update count" of the individual statements will indicate how many rows would be updated or deleted by a statement without any of the updates or deletions being committed. If you want the changes to applied, you can change the SQL script's Run Options to "Commit after each statement" or "Commit on completion".
We could ideate on mechanisms to reduce the number of clicks in this process... but it would likely be a variation of Re-execute this script with a different "Action when a script runs successfully" option such as "Commit after each statement" or "Commit on completion" if the script was previously executed using the "Roll back changes on completion" option.
Another option could be to enable a Run Option that would neither automatically COMMIT or ROLLBACK statements, but rather require users to explicitly execute COMMIT; or ROLLBACK; statements from their within their scripts.
Seria una excelente opcion para evitar errores o modificacion de mas a las bases de datos.
Por favor, para una mejor experiencia con IDZ y mejores resultados en el día a día, al contar con este beneficio. Gracias.
Seria una actualización muy util en el día a dia.
Muy necesario
It would be very useful to review the status of the query execution
Buena idea mas facil de usar
Being able to graphically insert the records as was done in the old emulation
Yes, this feature is available in Host emulation, and I think the DB2 for z/OS tool should have this function to give me more precision in my work.
This feature is available when doing a similar action directly on the host.