Rocket MultiValue

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------------------------------

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------------------------------

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------------------------------

what does this error mean? { "errorMessage": "Failed to handle the request", "resolution": "Please contact your web services administrator", "errorDetailMessage": "Exception: Failed to complete calling a subroutine: asjava.b.x: Unable to load the subroutine on the server", "errorCode": 15001 }

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------------------------------

Everyone out there know about D3's SET-DATE-WINDOW utility? It's something you can add to your cold start procedure to change the 2-digit year pivot point from 30 to something else. Example if you ICONV a date like 8/1/31, you'll get an internal date in the year 1931, not 2031 as you might expect. I have this in my USER-COLDSTART:SET-DATE-WINDOW 60This tells my D3 system to assume that any two-digit years from 00 to 59 are 2000 to 2059, where 60 to 99 are 1960 to 1999. This is a LOT handier than handling it in your application.I'm posting this because there's a lot of useful stuff in D3 that I was unaware of until I became a Rocket employee and was actually forced to read the manual. Maybe some of you are in the same boat.https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/103/refman/index.htmhttps://www3.rocketsoftware.com/rocketd3/support/documentation/d3server.jsp------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software-----------

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------------------------------

Hi, all. I used to work for a Rocket UniData client who was able to restrict permissions on production in such a way that for designated production logins, it was not possible to write to disc. One could use the editor, but not file the record; no compiles or catalogs; no file creation; etc. Is there a documented way of setting up this feature? [It has obvious implications for SOX compliance.]------------------------------Ken CibellideveloperRocket Forum Shared Account------------------------------

After working through the extension quick setup I am getting this popup messageMy current settings are This is what is in the directoryC:\\OpenJDK\\jdk-11\\bin>java -versionopenjdk version "11" 2018-09-25OpenJDK Runtime Environment 18.9 (build 11+28)OpenJDK 64-Bit Server VM 18.9 (build 11+28, mixed mode)C:\\OpenJDK\\jdk-11\\bin> So what is so "irregular" about this setup, and how do I fix this?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

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------------------------------

We have dozens of SOAP web services in production that were built using Web Services Developer Tool v4.23.0 (2017).  We now need to build RESTful web services and find the equivalent tool is RESTful Web Services Developer v4.63.0 (2017).These both seem to have been abandoned by Rocket in favor of MVIS.  The  MVIS data sheet says it requires UV 11.3.3 and we are currently running UV 11.3.1.  As we are going into a busy time of year, we cannot consider a UV upgrade until early 2023 at best.  However, we need to create. test and publish REST services in the next few months. Does anyone have any advice?

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

We're ready for the next round of testing of D3 Linux v10.4 Port!! Since the last round of testing, we have been working hard to make a more complete product. We have addressed a number of bugs, but more exciting than that is that we have added the FSI to our UNIX implementations. This allows us to offer the most highly horizontally scalable multi-value solution on the Unix platforms as we have previously offered on Windows. By decoupling the FSI and VME environments, you can achieve a more seamless cloud experience. Creating a docker instance of your application server (VME) while still utilizing a singular shared Database (FSI) can give you easily deployable instances of your application. If you are interested in assisting us with this exciting newly-architected product, please reply to this post, or email trude@rocketsoftware.com. We are looking forward to working with you again.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software-----------

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

Hi allJust your thoughts on how much memory should be allocated to a system with < 20 users? (NO Flash basic - Linux D3 (Ver 7.4))The users are complaining that the system is "slow" with 2.62144 TB. (yes you read correctly 2.62144 Terra Bytes) !In my opinion, this is FAR TOO much - and should be reduced to say 16 GB otherwise there is the chance of (per manual) "High values can result in poor performance of other UNIX processes due to inadequate remaining memory."What say you?------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

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 seen a bunch of changes through the years on additional functionality on this tool. Is there a comprehensive list of what this tool currently can do? I am a VAR and one of my clients expressed interest in it and I cannot find anything on the website.Below are a bunch of questions about the functionality this product has: How does it keep the connection alive if I am in a zoom meeting for 4 hours? Does it allow record locking on the server while I am editing it? Is there a before Read Call? Is there an after Write Call? Is there an after Delete Call? Is there an automatic save after so many minutes? Is there an option if not locked it can tell me the original has been updated? Is there an option when I compile in Unidata I can request the BASICTYPE? Is there a way I can put bookmarks, tasks, or information locally and not in the code? Is there a key sequence I can get where I can get syntax help for commands such as CASE, READNEXT, etc? Is there a way I can get actual errors as

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