Skip to main content

The __V_VIEW file

  • July 18, 2022
  • 5 replies
  • 0 views
Grant Boice
Hello Forum Members!

I have a question and hope someone can point me in the right direction.    

I recently stumpled across the a file directory named __V__VIEW.     It appears it has something to link UniData to an SQL environment.   

My question is this....  Where can I find documentation on this?    I can seem to find it or maybe I'm looking in the wrong places.

If someone could lead me into the right direction, I will be most appreciative!!!

Thank you for your time and consideration in advance.

Sincerely,

------------------------------
Grant Boice
Principal Software Developer
Matheson Tri-Gas Inc.
3 Mountainview Road
Warren, NJ 07059
------------------------------

    5 replies

    Jonathan Smith
    Forum|alt.badge.img
    • Jonathan SmithRocketeer
    • Rocketeer
    • 356 replies
    • July 19, 2022
    Hello Forum Members!

    I have a question and hope someone can point me in the right direction.    

    I recently stumpled across the a file directory named __V__VIEW.     It appears it has something to link UniData to an SQL environment.   

    My question is this....  Where can I find documentation on this?    I can seem to find it or maybe I'm looking in the wrong places.

    If someone could lead me into the right direction, I will be most appreciative!!!

    Thank you for your time and consideration in advance.

    Sincerely,

    ------------------------------
    Grant Boice
    Principal Software Developer
    Matheson Tri-Gas Inc.
    3 Mountainview Road
    Warren, NJ 07059
    ------------------------------
    Grant,

    The __V__VIEW file is maintained by UniData itself when for example you create a view or convert a file to a table via UniData SQL or via using the Visual Schema Generator Tool  (VSG).  The structure of the file is not formally documented as it is an internal file to UniData.

    Bearing in mind it's an internal file to UniData is there anything more that you want to know about the file.

    Regards,


    ------------------------------
    Jonathan Smith
    UniData ATS
    Rocket Support
    ------------------------------
    Jonathan Smith
    Forum|alt.badge.img
    • Jonathan SmithRocketeer
    • Rocketeer
    • 356 replies
    • July 19, 2022
    Hello Forum Members!

    I have a question and hope someone can point me in the right direction.    

    I recently stumpled across the a file directory named __V__VIEW.     It appears it has something to link UniData to an SQL environment.   

    My question is this....  Where can I find documentation on this?    I can seem to find it or maybe I'm looking in the wrong places.

    If someone could lead me into the right direction, I will be most appreciative!!!

    Thank you for your time and consideration in advance.

    Sincerely,

    ------------------------------
    Grant Boice
    Principal Software Developer
    Matheson Tri-Gas Inc.
    3 Mountainview Road
    Warren, NJ 07059
    ------------------------------
    Grant,

    If you need some more insight into what goes into the file (and it's associated files) the following documents may help you

    https://docs.rocketsoftware.com/bundle/U2ClientsAndAPIs_VSGSchemaAPIUserGuide_V521/resource/U2ClientsAndAPIs_VSGSchemaAPIUserGuide_V521.pdf

    https://docs.rocketsoftware.com/bundle/UniData_UsingUniDataSQL_V823/resource/UniData_UsingUniDataSQL_V823.pdf

    https://docs.rocketsoftware.com/bundle/UniData_SQLCommandsReference_V823/resource/UniData_SQLCommandsReference_V823.pdf


    Regards,



    ------------------------------
    Jonathan Smith
    UniData ATS
    Rocket Support
    ------------------------------
    Grant Boice
    • Grant Boice
    • Author
    • Participating Frequently
    • 10 replies
    • July 19, 2022
    Grant,

    If you need some more insight into what goes into the file (and it's associated files) the following documents may help you

    https://docs.rocketsoftware.com/bundle/U2ClientsAndAPIs_VSGSchemaAPIUserGuide_V521/resource/U2ClientsAndAPIs_VSGSchemaAPIUserGuide_V521.pdf

    https://docs.rocketsoftware.com/bundle/UniData_UsingUniDataSQL_V823/resource/UniData_UsingUniDataSQL_V823.pdf

    https://docs.rocketsoftware.com/bundle/UniData_SQLCommandsReference_V823/resource/UniData_SQLCommandsReference_V823.pdf


    Regards,



    ------------------------------
    Jonathan Smith
    UniData ATS
    Rocket Support
    ------------------------------
    John,

    That you VERY, VERY MUCH for the links and information!!

    I've been working with UniData/UniVerse and yes, "Prime Information" for 30+ years and learned something brand new, yesterday.

    Thank you very much for your response!! It is GREATLY APPRECIATED!!

    Sincerely,

    Grant W. Boice, Jr.
    Principal Software Developer
    Matheson Tri-Gas, Inc.
    3 Mountainview Road, 3rd Floor
    Warren, NJ 07059

    Office: 908-991-9225
    Email: gboice@mathesongas.com
    Paul Chang
    Forum|alt.badge.img
    • Paul Chang
    • Participating Frequently
    • 33 replies
    • July 19, 2022
    John,

    That you VERY, VERY MUCH for the links and information!!

    I've been working with UniData/UniVerse and yes, "Prime Information" for 30+ years and learned something brand new, yesterday.

    Thank you very much for your response!! It is GREATLY APPRECIATED!!

    Sincerely,

    Grant W. Boice, Jr.
    Principal Software Developer
    Matheson Tri-Gas, Inc.
    3 Mountainview Road, 3rd Floor
    Warren, NJ 07059

    Office: 908-991-9225
    Email: gboice@mathesongas.com
    It is a very important system file for the UniData SQL Schema. The user should not need to make any change on that file. Some UniData customers might corrupt that file for some reasons. It can be copied from a new UniData account to work from there. But, the previously created user's tables or views are not usable any more.

    ------------------------------
    Paul Chang
    Principal Technical Support Engineer
    Rocket Internal - All Brands
    ------------------------------
    Grant Boice
    • Grant Boice
    • Author
    • Participating Frequently
    • 10 replies
    • July 19, 2022
    It is a very important system file for the UniData SQL Schema. The user should not need to make any change on that file. Some UniData customers might corrupt that file for some reasons. It can be copied from a new UniData account to work from there. But, the previously created user's tables or views are not usable any more.

    ------------------------------
    Paul Chang
    Principal Technical Support Engineer
    Rocket Internal - All Brands
    ------------------------------
    Paul,

    Thank you for the response. Our goal was not to make changes or to remove this file, but to understand its functionality.

    We might need to leverage this in our future, potential projects that we are thinking about.

    Appreciate the advice!!!

    Regards,


    Grant W. Boice, Jr.
    Principal Software Developer
    Matheson Tri-Gas, Inc.
    3 Mountainview Road, 3rd Floor
    Warren, NJ 07059

    Office: 908-991-9225
    Email: gboice@mathesongas.com


    Terms & ConditionsAccessibility statement