Re: Cross Reference Tables on AS/400 -- JAVA400-L

I believe they are in the SQL System Catalog, which I believe is in the same 
library where the tables were created.
Actually, if the table is created in a library (as opposed to in a collection), 
the system catalog is in the QSYS2
Library. Refer to book "DB2 for OS/400 SQL Programming".



Franco Biaggi wrote:

> We had the same problem,
> the only way that I know is to run a RCLSTG with the appropriate parameter...
>
> On Wed, 27 Mar 2002 12:40:10 -0600, Tanveer, Mohammad wrote:
>
> >Does anyone know where the cross reference tables are on AS/400 and how to
> >clean them.  When I create tables on AS/400 using long SQLnames for example
> >EBPRODUCTTODESC, OS/400 creates a physical file like EBPROD00001 and stores
> >a relationship in O/S tables, it does the same thing for field names.  I
> >need to know in which table these relationships are stored and how to clean
> >or repair them.  Instead of using Reclaim Storage command which requires me
> >to put AS/400 in restricted mode.
> >
> >When I run my SQLStatments from Java :-) to create tables i get OS system
> >error.  When I tried to run them on AS/400 I got a message in my job log
> >saying OS System Error.  And solution is that i need to reclaim storage.
> >
> >N e Help Appreciated !
> >Thanks
> >
> >_______________________________________________
> >This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
>mailing list
> >To post a message email: JAVA400-L@midrange.com
> >To subscribe, unsubscribe, or change list options,
> >visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> >or email: JAVA400-L-request@midrange.com
> >Before posting, please take a moment to review the archives
> >at http://archive.midrange.com/java400-l.
> >
>
> <html>
>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> <meta name="Author" content="Franco Biaggi">
> <meta name="GENERATOR" content="Franco Biaggi">
> </head>
>
> <body>
>
> <p>&nbsp; </p>
>
> <table BORDER="1" COLS="1" WIDTH="452" BGCOLOR="#FFFF00">
>   <tr>
>     <td width="446"><font face="Comic Sans MS"><small><small><br>
>     <font color="#3333FF"><a href="http://www.ticino.com/usr/fbiaggi/";>Franco 
>Biaggi</a></font><small><br>
>     <font color="#3333FF"><a href="http://www.sisa.ch";>SISA Studio 
>Informatica SA</a></font><small><small><small> <br>
>     </small></small></small><font color="#3333FF">R&amp;D 
>Services</font><small><small><small>
>     <br>
>     </small></small></small><font color="#3333FF">Via Carvina 
>1</font><small><small><small> <br>
>     </small></small></small><font color="#3333FF">CH-6807 
>Taverne</font><small><small><small> <br>
>     </small></small></small><font color="#3333FF">Efax +1 801 705 
>2839</font></small></small></small><br>
>     </small></small></small><font color="#3333FF">Tel. +41 91 935 75 35&nbsp; 
>Fax. +41 91 935
>     75 30</font></small></small></small><br>
>     </small></small></small><font color="#3333FF">Sorry for my bad 
>english...</font><small><small><small> <br>
> </font></td>
>   </tr>
> </table>
> </body>
> </html>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
>mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.