[U2] How to fnuxi a SQL table

2011-11-03 Thread Mark Eastwood 
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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] How to fnuxi a SQL table

2011-11-03 Thread David Jordan 
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
Sent: Friday, 4 November 2011 8:53 AM
To: u2-users@listserver.u2ug.org
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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users