ACS - Run SQL Scripts - Insert From Examples

Ricky Thompson Ricky Thompson

Ricky Thompson

IBMi Software Engineer

发布日期: 2023年11月2日
+ 关注

I'm forever saving SQL Scripts from ACS to a PC file. Not that this is a bad habit or anything but finding them for later can be cumbersome. You can save SQL Scripts that you reuse often pull them back up again from inside Run SQL Scripts. I'm not sure how long this has been available but my boss showed this to me recently. You can click Edit/Examples/Insert from Examples.

This will bring up a new window with a list of pre-defined IBM examples.

You can search the descriptions to find a specific example. You can also save custom examples. And easily retrieve them again.

Now when you need to retrieve that query that you run fairly often by just going back to Edit/Examples/Insert from Examples. You can also search by the description.


Rob Berendt

System Analyst/Security at Group Dekko, #IBMChampion

1 年

I think your new example may not show until you restart Run SQL Scripts.

赞
回复
查看更多评论

要查看或添加评论，请登录

Ricky Thompson的更多文章

  • Splitting a PDF with RPG and Java PDFBox based on Text
    2024年10月10日

    Splitting a PDF with RPG and Java PDFBox based on Text

    So this is a follow up article to my previous example of just splitting each page of a PDF document. See the previous…

  • Splitting a PDF with RPG and Java PDFBox
    2024年10月7日

    Splitting a PDF with RPG and Java PDFBox

    I saw a post on Facebook asking if there was a way to split a PDF. While the poster didn't specify how he was splitting…

    9 条评论
  • RPG End Code Blocks - VS Code Extension
    2024年4月30日

    RPG End Code Blocks - VS Code Extension

    I have been trying to use VS Code - Code For IBMi more to get used to it. One of the things I missed in VS Code vs RDi…

    8 条评论
  • DB2 HTTP_POST
    2024年4月12日

    DB2 HTTP_POST

    In the past when I was trying to learn how to use some webservices and there was a site that basically allowed you to…

    3 条评论
  • Using SQL Lateral
    2024年2月9日

    Using SQL Lateral

    I think we have probably all seen a table that we wish was designed a little differently. Like lets take a…

    3 条评论
  • Part 3: Parsing Complex JSON Objects with DB2 SQL
    2024年1月8日

    Part 3: Parsing Complex JSON Objects with DB2 SQL

    So this credit goes to Birgitta Hauser, I had e-mailed her prior to posting the last two articles asking for some help…

    10 条评论
  • Part 2: Parsing Complex JSON Objects with DB2 SQL
    2024年1月5日

    Part 2: Parsing Complex JSON Objects with DB2 SQL

    In the previous article, it showed how to parse a complex JSON article but I wanted to add how you might process that…

    1 条评论
  • Parsing a Complex JSON with DB2
    2023年12月31日

    Parsing a Complex JSON with DB2

    I recently needed to parse a pretty complex JSON object with DB2 SQL. This isn't the easiest thing in the world to do.

    5 条评论
  • Generating the SQL DDL from an existing table
    2023年10月20日

    Generating the SQL DDL from an existing table

    Every so often I see someone ask how they can generate the DDL from a Table, PF, View, or Procedure . Maybe the source…

    2 条评论
  • ILEastic / JQuery
    2023年6月2日

    ILEastic / JQuery

    Do you remember the days of getting those AS/400 magazines that would have code in them that you could actually use…

    5 条评论

社区洞察

其他会员也浏览了