Scott and Tim cover these changes in their "iSee" videos, so that might be helpful to you. But I acknowledge that isn't really "documentation" and it would be ideal for these features to be documented within the tool itself or in some centralized part of the Knowledge Center.
I even tried finding something from the front page of the Knowledge Center. If you search for ACS, Access Client Solutions, DB2 for i, or even IBM i there are zero results. That's pretty sad!
There's an "ACS Updates" page here: https://www.ibm.com/support/pages/ibm-i-access-acs-updates where none of the reference URLs are actually clickable hyperlinks.
So I'd say you're right, they could do a better job making these details available and accessible.
------------------------------
Steven Riedmueller
Certified IBM i Admin
Speaker, Mentor, and Advocate
------------------------------
Original Message:
Sent: Fri October 13, 2023 07:49 AM
From: Robert Berendt
Subject: Reference question
Let's say you wanted to use a relatively new feature, like prompting on a SQL statement. Where would you find the reference on how to do that?
The Help, Help Contents in Run SQL Scripts is of no help in this.
https://www.ibm.com/support/pages/ibm-i-access-acs-updates says the following
- Prompt for statement variables https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-1883
Well that idea says I should be able to try prompting like [User ID]. However this results in
SQL State: 42601 Vendor Code: -104 Message: [SQL0104] Token [ was not valid.
If I try searching Examples for prompt I get nothing.
I know that I can use a question mark but where is the reference on this?
------------------------------
Robert Berendt IBMChampion
------------------------------