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

Hi
I was able to get the table names using
String [] types = {"TABLE"};
ResultSet rs =
connection.getMetaData(.getTables(null,"CXASHTEST",null,
types);

But now my problem is how do i get "CXASHTEST", or
basically the database name.

for example if i create a connection using the below
URL, how do i get the database name from connection.

jdbc:as400:148.168.77.12/CXASHTEST;user=abc;password=pass;naming=SQL;date
format=iso;time format=hms;prompt=false

I tried getCatalogs(), which returns AS400 name,
I tried getSchemas(), which returns all the collection
names.

What i am trying to write a utility which will allow
me to get data from all the tables in one collection
in XML file, 


Ashish





--- Sarah Poger Gladstone <listmember@xxxxxxxxxxxxxx>
wrote:

> Ashish- Try using the method to see all the types
> recognized by your AS/400:
> 
> con1.getMetaData().getTableTypes();
> 
> When I use this method against my as400, I get:
> "TABLE",  "VIEW"  and
> "SYSTEM TABLE".
> 
> In the past I have noticed that any file created
> from DDS is type
> "SYSTEM TABLE" and any file created using SQL is
> type "TABLE" But I
> have not seen this documented anywhere by IBM.
> 
> HTH,
> Sarah Poger Gladstone
> 
> On 12/15/05, Colin Williams
> <colinwilliams007@xxxxxxxxx> wrote:
> > Ashish,
> >
> > the other way to get this sort of information is
> to query the SQL cross
> > reference files
> >
> > eg SYSTABLES has info on all the tables in the
> system
> >
> > cheers
> > Colin.W
> >
> >
> > On 14/12/05, Ashish Kulkarni
> <kulkarni_ash1312@xxxxxxxxx> wrote:
> > >
> > > Hi
> > > Thanx, i am now able to get all the table names
> in
> > > CXASHTEST collection by using the following
> command
> > > rs =
> > >
>
connection.getMetaData(.getTables(null,"CXASHTEST",null,
> > > types);
> > > This also bring QRPGLESRC as table, but i guess
> i
> > > cannot filter it out
> > >
> > > Ashish
> > >
> > > --- Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx>
> wrote:
> > >
> > > > If you want all table leave tableNameMask as
> null:
> > > >
> > > > ResultSet rs =
> > > > connection.getMetaData().getTables(null,null,
> > > > null,types);
> > > >
> > > >
> > > >
> > > > Ashish Kulkarni wrote:
> > > >
> > > > >Ohh
> > > > >no i copied it wrong i want all tables, the
> > > > statement
> > > > >i have is
> > > > >String types[] = {"TABLE"};
> > > > >
> > > > >ResultSet rs =
> > > >
> >connection.getMetaData().getTables(null,null,"",
> > > > >types);
> > > > >
> > > > >Ashish
> > > > >
> > > > >--- Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx>
> wrote:
> > > > >
> > > > >
> > > > >
> > > > >>==>
> > > >
> >>connection.getMetaData().getTables(null,null,"A",
> > > > >>types);
> > > > >>
> > > > >>Do you have a  table name "A". Do you want
> to
> > > > >>specify "A*"?
> > > > >>
> > > > >>
> > > > >>
> > > > >>Ashish Kulkarni wrote:
> > > > >>
> > > > >>
> > > > >>
> > > > >>>Hi
> > > > >>>I am trying to retrieve all the table names
> from
> > > > a
> > > > >>>collection or library,
> > > > >>>
> > > > >>>Here is what i am doing
> > > > >>>
> > > > >>>
> > > >
> > >
>
>>Class.forName("com.ibm.as400.access.AS400JDBCDriver");
> > > > >>
> > > > >>
> > > > >>>DriverManager.getConnection("
> > > > >>>
> > > > >>>
> > > >
> > >
>
>>jdbc:as400:IP/CXASHTEST;user=user;password=pass;naming=SQL;date
> > > > >>
> > > > >>
> > > > >>>format=iso;time format=hms;prompt=false");
> > > > >>>
> > > > >>>String types[] = {"TABLE"};
> > > > >>>
> > > > >>>ResultSet rs =
> > > >
> >>>connection.getMetaData().getTables(null,null,"A",
> > > > >>>types);
> > > > >>>
> > > > >>>
> > > >
> > >
>
>>PrintDatabaseMetaDataAndResultset.printMetaDataAndRs(rs,true);
> > > > >>
> > > > >>
> > > > >>>while(rs.next())
> > > > >>>{
> > > > >>>   list.add(rs.getString("TABLE_NAME"));
> > > > >>>}
> > > > >>>   rs.close();
> > > > >>>
> > > > >>>But i am getting list size as '0'
> > > > >>>What am i doing wrong
> > > > >>>
> > > > >>>Ashish
> > > > >>>
> > > >
> > >
>
>>>__________________________________________________
> > > > >>>Do You Yahoo!?
> > > > >>>Tired of spam?  Yahoo! Mail has the best
> spam
> > > > >>>
> > > > >>>
> > > > >>protection around
> > > > >>
> > > > >>
> > > > >>>http://mail.yahoo.com
> > > > >>>
> > > > >>>
> > > > >>>
> > > > >>>
> > > > >>--
> > > > >>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
> > > > >
> > > > >
> > > >
> > > > --
> > > > 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
> > > --
> > > 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.
> > >
> > >
> > --
> > 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.
> >
> >
> 
> -- 
> 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