Software and Services for IBM i (iSeries/AS400)
Ask a question
1000 characters left

                                             

IBMi Change Control

IBMi Security & Auditing

IBMi Software Support

IBMi Development

 

IBMi SQL Services with Open Source and Python(2)

 

Following on from the previous post regarding Python and IBMi SQL services, I have updated the application to include a new service regarding Exit Points.

Here is what I have added. 

The IBMi SQL Service View to view 3rd party registered Exit Points.

The following SQL extracts data for this view:

SELECT EXIT_POINT_NAME,EXIT_POINT_FORMAT,REGISTERED,COMPLETE,EXIT_PROGRAM_NUMBER,EXIT_PROGRAM_LIBRARY,EXIT_PROGRAM

  FROM QSYS2.EXIT_PROGRAM_INFO                 

  WHERE EXIT_PROGRAM_LIBRARY NOT LIKE 'Q%'     

  AND EXIT_PROGRAM_LIBRARY NOT LIKE 'REGISTER%'

  ORDER BY EXIT_POINT_NAME, EXIT_PROGRAM_NUMBER 

I have only selected non-IBM library exit programs using the where clause. This runs on the latest TR on 7.3.

Contact us using the contact link if you are interested in additional services or options using this program, the full source is available for the previous version of this program.

#ibmi, #opensource, #sql, #python

IBMi Security,Tools ,Change Control and Support