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.