PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/18/2017 12:57 PM by  LauaLuau
Where do SQL Procs go???
 1 Replies
You are not authorized to post a reply.
Author Messages
Sr Systems Analyst
New Member
(6 points)
New Member

Send Message:

12/05/2017 12:42 PM
    IPD v11.0.1.43,  single tenant, cloud, SQL Server.

    A developer had created a SQL Procedure using the 'Create/Update SQL Procedure' option. 

    Now that proc is available to me in the 'Run SQL Procedure' option -> Select -> 'SQL Procedure Selector' window.

    Original developer then deleted that SQL node from his original flow.  The proc exists, but we don't have a copy of the original source.

    Is there any way for us to view the SQL behind that proc?

    Does it actually create a stored procedure on the SQL Server database?  If so, where? Which db/schema?  If not, is it in a delivered table/business class that I can query and see the SQL source code?


    ABAP Programmer / Infor System Administrator
    Bexar County
    Basic Member
    (14 points)
    Basic Member

    Send Message:

    12/18/2017 12:57 PM
    I haven't created stored procs for processflow but,

    Since you know the name of the procedure you might be able to find it with:

    select *
    where ROUTINE_NAME like '%the_name%'
    You are not authorized to post a reply.