Rocket® U2 | UniVerse & UniData®

Hi I'm currently trying to embed unidata commands in C# code - I'm aware of the U2.data.client dll available and have been using it, however the most recent .NET framework that it is recognized in is v4.8 - is there a package i could use in .NET framework v6?Just for a bit of context - I'm trying to build an API in  C# on azure that can access our Unidata accounts and present information in a somewhat rational view, my first steps would be to get some sort of C# API working through an http call.------------------------------Magdelene MuthusamyMissRocket Forum Shared Account------------------------------

U2 DBTools version 4.5.0 has been released on October 18 2022 for the below platforms/versions:Windows       Windows 10,  Windows 11,  2012,  2016,  2019,  2022This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact rbc@rocketsoftware.com.

U2 Clients version 5.3.0 has been released on October 18 2022 for the below platforms/versions:Windows       Windows 10,  Windows 11,  2012,  2016,  2019,  2022This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact rbc@rocketsoftware.com.

UniVerse version 12.2.1 has been released on October 18 2022 for the below platforms/versions:AIX POWER       7.1,  7.2AlmaLinux       8CentOS       7,  8Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Rocky Linux       8SuSE Linux Enterprise Server Intel       12.0,  15.0Windows       Windows 10,  Windows 11,  2012,  2016,  2019,  2022This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact rbc@rocketsoftware.com.

Can Unidata do SFTP?  I have written socket language interfaces to SMTP and others.  Is it the same type of interface for SFTP?  I'm having a hard time finding the direct interface commands it needs.  I can connect and get info from the socket but it never asks for User name/Password.Most of the google results point to using WinSCP, but i'd rather do the commands myself.  Anyone been down this path?------------------------------David GreenComputer ProgrammerRocket Forum Shared Account------------------------------

We have been asked to provide a rough storage estimate for moving a Universe DB to SQL Server.  Any general rules of thumb for estimating storage use on the new platform?  I'm not familiar with Universe, but from what I've been able to gather the record and index storage is very different.  Thank You------------------------------donald TiptonDBARocket Forum Shared Account------------------------------

I am running Universe 11.3.4 on RHEL 7.7 using AccuTerm 7.3a as my emulator. When I login normally my backspace works. I need to use root permission for some of my phantoms. At TCL prompt I will SH to Unix level then su to root then uv back to universe. My backspace key quits working.  I can manually fix it by running a PTERM command. Is there away to permanently fix this?Jon CardCombined Transport Inc

Thanks for the response Henry, I would like to receive some information on your offering. dalekelley@dalewkelleyinc.comDale>>>> Hi Dale,>> Integration with Esri ArcGIS is a core part of our UniVerse-based > solutions. We use several different ArcGIS APIs to both provide > information to ArcGIS and retrieve information therefrom, include > REST, JavaScript, and GeoEvent over WebSocket. Use of those method > also provides the data to ArcGIS to construct Esri ArcGIS Dashboards.>> Henry>> *Reply to Group Online > * > *View Thread > * > *Post New Message Online > *>

I have a UniVerse customer, a county highway department.  Over the years we have accumulated a lot of lat/lon coordinates for different resources.  I would like to propose adding a GIS interface to the system.  My question, has anyone already done this to any multi value database and can you suggest products to research?  I have looked, a little, at ArcGIS because they have some low cost online training.

Reading the documentation for @ Variables, it seems inconsistent for @DAY to come from the established @DATE, yet the other, similarly named variables should be based on the current date. Variable Read-Only Value @DATE Internal date when the program was invoked. @DAY Day of month from @DATE. @MONTH Current month. @YEAR Current year (2 digits). @YEAR4 Current year (4 digits). The following experiment confirms the current-date @ variable documentation does not reflect the behavior of UniVerse 11.3.1.6022. All values relate to the established @DATE value. Disabling automatic date and time, set the clock to late New Year's eve, run the program, celebrate the new year, and let the program finish. AtDay 0001 program AtDay 0002 0003 D = DATE() 0004 print "DATE(): ":DATE():", ": OCONV(D,"D4/") 0005 print "@MONTH: ":@MONTH 0006 print "@DAY: ":@DAY 0007 print "@YEAR: ":@YEAR 0008 print "@YEAR

Registered yet?Join the MV product management team in two weeks to learn about what's new and what's next in the Rocket MultiValue product segment. There will be two sessions so we hope one will fit your schedule. Register here: https://info.rocketsoftware.com/MV-2022-Roadmap_LP.html------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY US------------------------------

Trying to run CONVERT.SQL but getting an error.  Not sure how to track this user down or change the owner.  Clearly that uid is not a windows guid.  The user id doesn't show up in LISTUSERS.  I'm an admin on the server but I'm not sure how that relates to a superuser in unidata.Thanks,Seb------------------------------Sebastian NahapetianRocket Forum Shared Account------------------------------

Hi Folks, newbie here.I have a UV account that I've backed up using uvbackup.  I want to restore that account under a different account name.  I'm not seeing any options on the uvrestore utility to do that.  I definitely don't want to overwrite the existing production account with what I backed up previously, just set up a duplicate (although outdated) test  account.  Does anyone have any pointers to restore, say, the ACCT as TEST_ACCT using the backup file I created as shown below?Backed up using:   D:\\U2\\UV\\bin\\uvbackup.exe -f -v -nodrive -walk D:\\dbms\\DATA1\\ACCT > D:\\UVBACKUP\\UVBACKUP_ACCT.UBK------------------------------Mark BakerSelect* Associates IncTimonium MD US------------------------------

Monday marks the pick Julien calendar roll from the 10 to 20 thousands. I'm sure most of you remember when we PICK folk went from four digits in our internal dates to five, back in 1995.Since then I've managed to create an entire additional adult human, as well as create umpteen lines of code.I felt the occasion was worth notice. Anyone have any anecdotal stories of that eventful day? Kathleen------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

hello One behavior of UV / Windows Port.Status that I have never resolved is the presence of Unavailable as the last process command. Which greatly slows down the output of port.status. Have you ever experienced  such a situation? sample There are currently 48 uniVerse sessions; 19 interactive, 29 phantom Pid.... User name. Who. Port name..... Last command processed.......10760 efv 9 Unknown Unavailable  8104 jcd -30 Unavailable  4132 jcd -43 Unavailable  8588 jcd -44 Unavailable 10660 jcd -46 Unavailable ------------------------------Manu Fernandes------------------------------

Years ago, in a different forum, someone posted a proc/paragraph they called LSELECT that, as I recall, allowed you to take a select list of values for a specific attribute in a file and select all the records in that file that contained any of the values in the select list. It was very clever.The machine I installed it on is long since off-line. If anyone else has it, I would love to recreate it on the machine I am on now.BTW, i am using Unidata 8.1

Hi allI've been doing some experiments accessing UniVerse data via Python for some time and I had my own library before the official Rocket uopy utilities were available to me.One thing I implemented is my own custom representation of a UniVerse record as a Python dictionary and I was wondering if it would be useful to anyone. Maybe I can add it to the Python github.Anyway, I'll explain the logic in my implementation and why I still use it in some places instead of the "natural" DynArrays.My implementation stems from the structure of a lot of the data we use here, as a lot of records are sparsely populated (I use to call my own records "sparse records" to differentiate them from the DynArray)Example: A register with 90 values, which only 4 contain real data. One of them is a multivalue that also contains several "empty" fields.1. "Value1"2. "Value2"3. ""4. ""...60. "a|b|c|d||||||||m|n"...90. "Value90"Using a DynArray results in a mostly empty list, with the footprint that this involves

Does a command exist for UniData that will list all the data files with triggers in a data account?I could write a routine to do it, but I'd rather not reinvent a wheel that exists.Thank you

Hello, I'm trying to put a copy of my production database into my Windows Personal Edition UniVerse 12.1.1.0 and it´s giving the message below: C:U2UVTEST>uvrestore -i ftp empIPL.LOCb Backup Date : Mon Sep 19 16:50:01 2022 Reel Number : 1 Compression/Encryption: Off Image Type : Full Backup (ver10 UNIX) Block Size : 8192 bytes NLS on : False FastWrite On : False Label : IPL Data Current device(s): ftp empIPL.LOCb IPL.LOC (Sep 19 14:50:01) File "IPL.LOC" has modulo 160309 which is > 10007. Please resize it to modulo <= 10007 in order to use it in Personal Edition. IPL (Sep 19 14:59:20) File "IPL" has modulo 145661 which is > 10007. Please resize it to modulo <= 10007 in order to use it in Personal Edition. Total files: 0 Total bytes : 0 Elapsed Time: 00:00:03 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. 0 ext

Greetings! We use the replication monitoring phantoms - MONITOR.REPLOG and MONITOR.REPSTATUS.  While we can start/stop/update them manually, we used to have a VB-based application to do so - provided to us by Rocket.  Unfortunately, we've lost that software.  If it's readily available for download on the Rocket site, we have not been able to find it there.Where can I find the VB software for controlling the replication monitoring phantoms?Thanks in advance!Brian Paige

hi folks,I have the session 99 into a READU statement and lock is owned by  port 10 ... then 99 appears into Active waiters as a Waiter and Owner is 10. Now, I want to MASTER OFF 99 ...  nothing occurs ! no message, no error, no result. Is anyone known a method to kill a 'lock Waiter' session ? with kind regards manu

Greetings! Has a newer version of the Extensible Admin Tool been released?  I just requested the 'trial download' from the Rocket site.  It sent me a download link, but the software it downloaded is the same version I already had - version 4.14.0, Build id: 20181218_2890, as part of DBTools version 4.4.0, from 2018.Is there a newer version - and if so, is there a way to get to it without going through the "sign up for a trial download" process?Brian Paige------------------------------Brian PaigeEnterprise Systems ManagerSerta /Simmons Bedding LLCDoraville GA US------------------------------

I have a customer using Accuterm 8 who are going to replace 3 of their workstations. Has anyone done this? I'm wondering about the license validation.Dale

Hi,I've installed Universe for Windows community edition.   I want to do a couple of things - install the Developer tools IDE and/or VS Code to edit BASIC programs, and, also test python code executing in Universe to utilise external python modules  and libraries.I can get to the XDEMO account at the BASIC MV shell, and LIST PRODUCTS data.I have tried and failed to connect the Basic Developer Toolkit. I cannot find what username/password to use. When connecting to my instance, what is the default username/password combination or should I set an account up and if so how ?  I think this will also help me connect up VSCode.As a follow up question, I have  python module which I want to include in a python program which I execute in Universe.  Is there specific process I need to run in order to include this module for use ?  I tried to run pip install <my module.whl> but this did not seem t import my module.Thanks - Steve------------------------------Stephen PisaniRocket Forum Shared

Hello all, wondering if anyone had any luck uploading to Amazon S3 using UniBasic/UniData.The requirement is to call Amazon S3 HTTP REST API directly in UniBasic, using AWS Signature Version 4. Are there any samples out there we can use?Thanks------------------------------Pedro RochaRunnerTechBoca Raton FL US------------------------------