With .sqlrpgle :

d USERID 358 367
d wUserName s 50
...
exec SQL
select CID.ODOBTX
into :wUserName
from Table( QSYS2/USERS() ) AS CID
where CID.ODOBNM = :USERID;

From:nelsonp@xxxxxxxxxxxxx
To:midrange-l@xxxxxxxxxxxx
Subject: Security question
Date: Thu, 19 Nov 2015 10:20:46 -0600

Folks,

Is there some sort of API that can retrieve just the text field associated
with a user profile?

I know that DSPUSRPRF to an outfile is possible, but the programmers are
looking for a faster way.

Paul Nelson
Cell 708-670-6978
Office 409-267-4027
nelsonp@xxxxxxxxxxxxx



This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].