Programming Languages on Power

Power Programming Languages

IBM Power, including the AIX, IBM i, and Linux operating systems, support a wide range of programming languages, catering to both traditional enterprise applications and modern development needs.


#Power


#Servers
#Programminglanguages
 View Only

  • 1.  ACS Development and Source

    Posted 02/25/22 03:01 PM

    How can we get the source from an ACS SQL stored procedure into SOURCE/QSQLSRC?  



    ------------------------------
    Amy Vozza
    ------------------------------

    #SQL


  • 2.  RE: ACS Development and Source

    Posted 02/25/22 03:24 PM
      |   view attached
    The source for any Db2 object that you create with the Generate SQL option that's available in the ACS Schemas tool.

    Just right-click on any object in the Schemas tool and select the Generate SQL option. As you can see in the attachment, the Generate SQL menu allows you to store the retrieved/generated SQL directly into a source physical file member.


    There's also two services, GENERATE_SQL & GENERATE_SQL_OBJECTS, if you want to do this programmatically.

    ------------------------------
    Kent Milligan
    ------------------------------



Related Content