Hi I can find information about all Schema i have authority, but i want to find out which schema was defined in the connection? is it possible to do that Ashish --- Sarah Poger Gladstone <listmember@xxxxxxxxxxxxxx> wrote: > Ashish- > > No matter which schema name you use in the > connection url, you can > retrieve data from any schema on that system that > your user profile > is authorized for. > > Using your url for connection: > "jdbc:as400:184.108.40.206/CXASHTEST;user=abc;password=pass;naming=SQL;date > format=iso;time format=hms;prompt=false" > > you could retrieve data from any schema on the > machine 220.127.116.11 > using a single open connection. You are not > restricted to the schema > that you provided in the url. It is not even > required to be specified > in the connection url. You could use the url: > "jdbc:as400:18.104.22.168;user=abc;password=pass;naming=SQL;date > format=iso;time format=hms;prompt=false" > > -Sarah Poger Gladstone > > > > -Sarah > > -- > This is the Java Programming on and around the > iSeries / AS400 (JAVA400-L) mailing list > To post a message email: JAVA400-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: > http://lists.midrange.com/mailman/listinfo/java400-l > or email: JAVA400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the > archives > at http://archive.midrange.com/java400-l. > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.