Re: How to get the current user ID after sign on to AS400

   The AS400 (connection) object has a .getUserID()
method that returns a String.
URL = "jdbc:as400://mysystem/database" +
myAS400.getUserID();

Hope this helps,
Don Whittaker

--- "Xu, Weining" <Weining.Xu@AIG.com> wrote:
> Hi, all,
>
> I have a program using JDBC driver to access DB2 on
> AS400.  I will let the
> different users to use different testing
> databases(libraries) on AS400.  So
> after the program connected to AS400, I need to know
> the user ID who just
> signed on AS400 in order to set up a URL as
> "jdbc:as400://mysystem/databaseXYZ".  Then use this
> URL to make a
> connection, such as:  con =
> DriverManager.getConnection(URL);
>
> Is there anyway I could get the current userID,
> something like:
>
> if (userID.equals("John")){
>       URL = "jdbc:as400://mysystem/databaseJohn";
> }
> else if (userID.equals("Tom")){
>       URL = "jdbc:as400://mysystem/databaseTom";
> }
>
> con = DriverManager.getConnection(URL);
>
> Thanks for any helps.
>
> Wayne
>
>
>
> _______________________________________________
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
>


__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/