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
Sort:
You are not authorized to post a reply.
Author Messages
dcasper70
Sr Systems Analyst
Private
New Member
(6 points)
New Member
Posts:4


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?

     

    LauaLuau
    ABAP Programmer / Infor System Administrator
    Bexar County
    Basic Member
    (14 points)
    Basic Member
    Posts:6


    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 *
    from DB_LAWSON.INFORMATION_SCHEMA.ROUTINES
    where ROUTINE_NAME like '%the_name%'
    You are not authorized to post a reply.