LDAP Query from DB2

I am not even sure how to ask my question or what I need to know to ask it correctly. Basically I am writing a SQL query in DB2 on power 8. I need to be able to query LDAP on the domino server to tell if a user exists in LDAP. How can this be done?

Subject: Domino ldap query from DB2 on IBM i

I speak fluent DB2 on IBM i. :slight_smile: I understand you loud and clear.

So, on IBM i, on a power 8 I can do the following against a domino server named ldap01 serving up ldap:

STRQSH

ldapsearch -h ldap01.corp.dekko.com -s one “cn=spratt

and I will get a list like this:

CN=Jack Spratt,O=DEKKO
cn=Jack Spratt
cn=jspratt

Now, you want to know how you can do this automatically from within a program (RPGLE or otherwise). Right?

I’ve not used these to do this automatically but it may be a good start

IBM Documentation http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/apis/dirserv1.htm?lang=en

You could subscribe to one of the lists at http://lists.midrange.com http://lists.midrange.com like midrange-l, rpg400-L, cobol400-l, or java400-l. The first two get a LOT of traffic.

Would be nice if there was an appropriate service for a straight DB2 answer like the services at: IBM Documentation http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajq/rzajqservicessys.htm?lang=en