I’m trying to use CONVERT.SQL on an a very old Unidata system on HPUX. I’m getting this error message. Can someone tell me what may have been removed from the VOC years ago? Other SQL commands seem to be OK, for now.
:CONVERT.SQL PETER
default name length 30 is used
'__V__VIEW' does not exist in VOC file.
Open view file error
+4Peter,
As a starting point in the account you are running the CONVERT.SQL command there should be the following VOC entry.
__V__VIEW
F
__V__VIEW
D___V__VIEW
So firstly check the VOC entry is there and then check to see if the data and dict levels of the file exist and that you have permissions to use them, before you decide what to do next.
For reference The __V__VIEW file and its dictionary D___V__VIEW are normally created when an account is set up via newacct. newacct copies __V__VIEW and D___V__VIEW from @UDTHOME/sys/ into the account.
Aside from not having the correct permissions to the files or someone deleting the VOC entry or files, then it could be that account was created before SQL view support was added, or was created by an older version of newacct that didn't include __V__VIEW.
Thank you
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
