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

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.
>
>