Hi Brian,
Regarding client special registers - below is a link to an article I recently wrote on this topic.
They are very useful for identifying the source of database requests.
http://ibmsystemsmag.com/Trends/02/2019/client-special-registers
I see other replies have pointed you in the right direction for the exit points.
Dawn
On Aug 7, 2019, at 7:54 AM, Brian Garland via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>> wrote:
Our IT department is asking for an exit program (based in IBM's direction)
to block ODBC access from Run SQL Scripts and other programs and only allow
a 3rd party SQL tool and our application through. IBM pointed then to exit
points but will not be more specific without a services contract. The 3rd
part tool is basically Run SQL Scripts but with extra logging and user
control (i.e. read-only queries). Our application uses either JDBC from
Java or ODBC from PHP to access the database.
I've looked into the exit points and found one that may help. I've also
seen comments about using special registers to know which app is calling.
My Google skills are failing me in finding anything useful. Is there any
good all in one write up on this process?
--
Brian J. Garland
Vermont Information Processing, Inc.
brian.garland@xxxxxxxxxx<mailto:brian.garland@xxxxxxxxxx>
--
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or company to whom they are addressed.
Do not disclose, distribute, or copy this email to others outside your
company. If you have received this email in error, please notify the sender
immediately and delete this email from your system.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
