Re: DBEXPORT/DBSCHEMA problem

In <2shria$5ji@panix.com> clay@panix.com (Clay Irving) writes: >I was using DBEXPORT to export a database from an OnLine 5.01.UD3 >engine running on SunOS 4.1.3 -- After exporting 348 tables, DBEXPORT >ABENDs with a 'syntax error'. I can see nothing wrong with the SQL >statement generated. So, I drop the table where DBEXPORT ABENDed and >run it again. This time, it ABENDs after export 347 tables. I drop the >table is ABENDs at and try again. You guessed it! It ABENDs after >dropping 346 tables! >This is a count of the tables and a du after each ABEND: >ls *exp | wc > 347 347 5199 >du >6780 ./shoe.exp >8347 . >ls *exp | wc > 346 346 5184 >du >6780 ./shoe.exp >8349 . >ls *exp | wc > 345 345 5169 >du >6780 ./shoe.exp >8351 . >I thought I was running into some type of system limitation, so I used >DBSCHEMA -- Lo and behold, it ABENDs in exactly the same place! >Obviously, there's a bug/error in the engine that I can't see... >Has anybody run into this before? I'm losing my mind... I have the answer -- I selected the next tabid from sysables and tabname was blank! How in the world does on create a blank table name?!! When I deleted this, both DBEXPORT and DBSCHEMA work ok.. Now let me tell you about the bug in DBIMPORT in the 5.02 OnLine! It ABENDs with a message, 'value of DECIMAL or Money exceeds maximum precision' -- There's only one decimal column in the table and all data is fine (hell, I just exported it from a 5.01 OnLine database on another system!). If I load the file in ISQL it works fine... Clay " helluva week " Irving -- Clay Irving clay@panix.com