Hi Mark I am sure I have fixed SQL Tables from uniadmin without any problems. Sometimes there are conflicts in schemas, you would use VERIFY.SQL SCHEMA schema FIX in other times, however I am not sure that will work for UV_TABLES in the UV account. You may also be running into an issue of SQL permissions above directory permissions.
David Jordan -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mark Eastwood Sent: Friday, 4 November 2011 8:53 AM To: [email protected] Subject: [U2] How to fnuxi a SQL table UV 10.0.13 on RH8.0 I tried to create a Trigger on a UV file, but got an error telling me to fnuxi the "UV_TABLES" file. But when I try to fnuxi it, I get another error saying it's an SQL file and may not be fnuxi'ed. Details Below. Any ideas how I can "fix" the UV_TABLES file? Note; this system has been running for 10+ years, and may have migrated from different hardware as some point Thanks, Mark >CREATE TRIGGER TEST BEFORE INSERT OR UPDATE OR DELETE ON VS FOR EACH ROW CALLING 'VS.TRIGGER'; ?Byte-swapped magic number in operating system file "/adv/uv/sql/catalog/UV_TABLES", use "fnuxi /adv/uv/sql/catalog/UV_TABLES" to convert. UniVerse/SQL: Unable to open UV_TABLES. > >ED VOC UV_TABLES 3 lines long. ----: L22 0001: F 0002: /adv/uv/sql/catalog/UV_TABLES 0003: /adv/uv/sql/catalog/D_UV_TABLES Bottom at line 3. ----: EX >SH $ cd /adv/uv/sql/catalog $ /adv/uv/bin/uv UniVerse Command Language 10.0 (c) Copyright IBM Corporation 2001. All rights reserved. catalog logged on: Tue Jul 5 08:15:29 2011 >LIST UV_TABLES Byte-swapped magic number in operating system file "/adv/uv/sql/catalog/UV_TABLES", use "fnuxi /adv/uv/sql/catalog/UV_TABLES" to convert. Unable to open "UV_TABLES" file. >SH $ /adv/uv/bin/fnuxi UV_TABLES Processing 'UV_TABLES'. File 'UV_TABLES' is an SQL file and may not be fnuxi'ed. $ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
