Re: retrieve table all table names from a collection using JT400

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