November 29, 2021 Paul Tuohy
By now, you should be well aware that Run SQL Scripts provides content assist (promoting) for Select statements (see Guru: ACS 184.108.40.206 Content Assist Includes Prompt For SQL! ). But did you know that you can also use content assist for stored procedures, table functions and parameters? Let’s see how it works, using some of the Integrated File System (IFS) procedures and functions provided by IBM i Services.
Prompting a Stored Procedure
Open Run SQL Scripts, type in:
Then press F4 (or Ctrl+Space). You will be presented with a list of all the stored procedures in the schema …Read more