Re: retrieve table all table names from a collection using JT400- How to get collection name

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:148.168.77.12/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 148.168.77.12
> 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:148.168.77.12;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