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

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