This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. 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 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
Add prompt variables to queries that run in the Run SQL Scripts application. This would allow generic queries to be reused for specific results. The Run SQL Scripts application would need a mechanism for entering the substitution variable data when the user runs the query. I would expect this to work similar to how it works in MS Excel / MS Query. If possible, it would also be a benefit to assign values to global variables using such prompting. Those global variables could then be re-used in multiple query statements.
Type a query in Run SQL Scripts and use either a question mark (?) or square brackets enclosing a prompt string to denote substitution variables that would be prompted for at run time. For example, a query to show user profile info for a select user... SELECT authorization_name, text_description, date(creation_timestamp) as create_date, date(last_used_timestamp) as last_used, date(previous_signon) as last_signon, sign_on_attempts_not_valid, status, date(password_change_date) password_changed, set_password_to_expire, user_default_password FROM QSYS2.USER_INFO ui where authorization_name = [User ID] ; A prompt would appear asking for a "User ID". You could also use a question mark for the substitution variable place holder. This query could then be copied into an application where you could use the embedded capabilities to specify substitution variables.
SET mylib.myvar = [prompt text];
select * from mylib.mytable where field1 = mylib.myvar;
select * from mylib.mytable2 where fieldx = mylib.myvar;
Do not place IBM confidential, company confidential, or personal information into any field.