PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/21/2017 9:38 AM by  dcasper70
Where do SQL Procs go???
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
dcasper70
Sr Systems Analyst
Private
Basic Member
(13 points)
Basic Member
Posts:7


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%'
    dcasper70
    Sr Systems Analyst
    Private
    Basic Member
    (13 points)
    Basic Member
    Posts:7


    Send Message:

    --
    12/21/2017 9:38 AM

    I realized that since the 'Create/Update SQL Procedure' option was used in the IPD, the proc was essentially created by the user specified in the configuration's jdbc entry.  In this case 'jdbcuser'.

    Since I do not have the jdbcuser ID & PW, I cannot see those procs.  

    They exist under LMGHRDB - Programmability - Stored Procedures for that user

    You are not authorized to post a reply.