|
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> </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&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 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>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.