ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

iACS v1.1.8.2 "for Update" option

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • iACS v1.1.8.2 "for Update" option

    The IBM i 7.3 Technology Refresh 6 and Portfolio Update page mentions the changes in iACS 1.1.8.2, including this one:
    "Leveraging the new "for Update" option, users who have access can update and edit the data values within a database table directly from Run SQL Scripts."

    Can anyone tell me how to use this?




  • #2
    Add FOR UPDATE at the end of your SELECT-Statement, execute your select statement and then go into the result and replace/override the values.

    Comment


    • #3
      That is really cool - I will be using his a lot!

      Thanks Birgitta

      Comment

      Working...
      X