Rocket MultiValue

If you are considering upgrading to Rocket® UniVerse 11.4.1 and use either Rocket SB/XA (all releases) or Rocket U2 Web DE 5.3.0 or below, you need to plan your upgrade to avoid disruption to your System Builder and Web DE applications. Rocket UniVerse 11.4.1 includes OpenSSL 3.0. With the upgrade of OpenSSL, we also disabled unsafe encryption algorithms including: Hashing Algorithms / Message Digests: MD2, MD4, MDC2, WHIRLPOOL, RIPEMD160 Symmetric Ciphers: Blowfish, CAST, DES (DES_ECB, DES_CBC, DES_OFB, DES_CFB, DES_CFB1, DES_CFB8 and DESX_CBC), IDEA, RC2, RC4, SEED Key Derivation Function (KDF): PBKDF1 Both SB/XA and U2 Web DE 5.3.0 (and earlier) rely on disabled encryption algorithms and won't work unless you reenable them. For SB/XA your options are: Enable legacy algorithms (instructions below) Postpone your UniVerse upgrade. We are working on a Hotfix for SB/XA 6.5.7 to upgrade the encryption algorithm used by SB/XA. We plan to release the hotfix before the end of 2023. For U

If you are considering upgrading to Rocket® UniVerse 11.4.1 and use either Rocket SB/XA (all releases) or Rocket U2 Web DE 5.3.0 or below, you need to plan your upgrade to avoid disruption to your System Builder and Web DE applications. Rocket UniVerse 11.4.1 includes OpenSSL 3.0. With the upgrade of OpenSSL, we also disabled unsafe encryption algorithms including:•    Hashing Algorithms / Message Digests: MD2, MD4, MDC2, WHIRLPOOL, RIPEMD160•    Symmetric Ciphers: Blowfish, CAST, DES (DES_ECB, DES_CBC, DES_OFB, DES_CFB, DES_CFB1, DES_CFB8 and DESX_CBC), IDEA, RC2, RC4, SEED•    Key Derivation Function (KDF): PBKDF1 Both SB/XA and U2 Web DE 5.3.0 (and earlier) rely on disabled encryption algorithms and won’t work unless you reenable them. For SB/XA your options are:•    Enable legacy algorithms (instructions below)•    Postpone your UniVerse upgrade. We are working on a Hotfix for SB/XA 6.5.7 to upgrade the encryption algorithm used by SB/XA. We plan to release the hotfix before the en

I sometimes see an error message when trying to re-license after an update (which I've been doing a lot recently to get customers up to 3003). "This web address is for US and Canadian customers of RBC.  Please click OK and click the indicated URL to continue." This is from https://rbc.rocketsoftware.com/authprod.asp.  I usually wait a day or two (but not ten!) and go through the process again and it usually seems to work.  I could be entering the details a different way the 2nd time?  The customers work with the VAR to get the license details, so I'm one step removed from requesting and managing the serial numbers, they just call me when they need help. Anyone else seen this, or have advice on what I'm doing wrong? ------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

I'm posting this to alert anyone who's got large multivalued attributes they may want to sum in AQL. A friend of mine logged a case recently where a correlative using the S() function would hang when the file has any items where the attribute in question has more than 32,768 values. Engineering confirmed that this is an AQL limitation because it's using a 16-bit signed variable to track the value count. This variable is used in many places in AQL, and it would be a huge task to rearchitect. In the course of debugging this, Engineering came up with a workaround by using CALL in the correlative. This not only removed the 32,768-value limit, but it is also MUCH faster. Example of the correlative that hangs (using multivalued attribute 9 in the example): 008 A;S(9) Example of the correlative that works (again using multivalued attribute 9 in the example): 008 call bp sumbal Might be a good idea to fully path the subroutine being called. Example of a subroutine in an account called "orders"

I saw some teasers for 8.2.5 a few months back - is there an online "what's coming soon" for Unidata anywhere?------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

Hello I am hoping someone can help with an AccutermIO query. We are following the instructions..... AccuTerm Release Information V8 and we are trying to create a profile. 2 Profiles already exist, thet were created prior to Rocket aquiring Zumasys. When we create a profile we are not getting a check box display for the Role (admin/dev).  We create the profile anyway, but when we launch Accuterm we get the error No profiles have been created. Please login to Portal and create one.  Can anyone please advise on what we are doing wrong. As an aside, the portal we are using is the Zumasys portal, https://zs-portal.rocketsoftware.com/accuterm, as this is where we were redirected.------------------------------Richard OldsSnr DeveloperCalidore Computer Systems LtdGATESHEAD GB------------------------------

I've been asked this before, but did not have an answer!  On Unidata -- in a dictionary -- to do a multivalue OCONV, the command is SUBR("-OCONVS",X,Y) The question I got asked:   "Why is there a "-" in front of that code?" And I was not sure!  Is that because it's a system function?  It's not actually documented as to WHY -- just that it IS. I just looked over the Using UnIData 8.2.4 doc to make sure it was not something documented. Anyone know for sure what the "-" infers or confers beyond my guess that is means 'this is a built in system command'?------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

This is the second MVX: Performance release focused on improving replication as part of a MultiValue HA/DR strategy.  This release includes a new replication dashboard allowing users to quickly and easily perform replication monitoring tasks to assess, in real time, the health of replication activities. The replication dashboard includes details such as a statistical summary of multiple distributions and identifies the stalled LSN causing a subscription group to stop processing. A stalled LSN has been the number one replication-related support case our customers have submitted. This version of MVX: Performance provides resolution steps without users having to reinitialize servers. The dashboard also displays trend information such as pacing time behind and time to catch up.  In addition, v1.8 features three new replication events: ·        Replication disabled event: generated for one event per distribution if any groups are disabled. ·        Replication down event: generated if repl

MultiValue Experiences version 1.8.0.1347 has been released on October 19 2023 for the below platforms/versions:AIX POWER       7.1,  7.2,  7.3AlmaLinux       8CentOS       7,  8RedHat Enterprise Linux Intel       7,  8,  9Rocky Linux       8Windows       Windows 10,  Windows 11,  2016,  2019This 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.

Nevermind, figured it out. Apparently this forum is an excellent rubber duck. If some kind soul at Rocket would add SQL.WLONGVARCHAR and SQL.WVARCHAR to ODBC.H that would be very nice.

I am on Universe. I get the following message when I try to delete a file.  "unable to unlink the operationg ssytem file" then it lists the file name. Then it follows with "DELETE failure". What does this mean and what can be done about it?------------------------------Konson GeeProgrammerLiahona Development SolutionsBonney Lake, WA, United States------------------------------

it comes with openssl 1.1.1n  it is possible to update the openssl version by: replace the version in udt version sym link to another version  update the path so it find the redhat version first some other way/suggestion that I am not aware of and will this break anything in udt? thanks dougc ------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

I believe I was told that when upgrading UDT from a previous version maybe 8.2.x to 8.2.4 its possible to update the license programmatically? currently we have to use confprod A message displays: You have 10 days to call U2 before UniData stops working.  5.      Type Ctrl+F to generate the configuration code.  6.      Copy the generated configuration code to the clipboard; it will be used to obtain the authorization from the vendor in the next section.  Note:   Consider saving a copy of the configuration code in a text file such as Notepad.    Obtain an Authorization Code  UniData is owned by Rocket Software. No log in is required to obtain a product authorization code.  Use this link to authorize UniData: https://u2tc.rocketsoftware.com/authprod.asp  2.      Read and follow the instructions on the web page.  3.      On the Rocket Web page, change the Select Product dropdown box to UniData and click Continue.  4.      Enter your eight-digit serial number, which is the license numbe

Good day, I'm supporting a IBM Power AIX environment, which I have been working with for about a year. Along with sorting out the general maintenance of the systems and moving to AIX 7.2 there is a large UniVerse environment on the hardware I support. So I've done a little reading, as I didn't build these environments, about recommend tuning. I couldn't find anything specific, so along with what I've found, I wanted to see if there was anything else I could do or look into. We have a number of test environments, and servers that I can build to test these things on.I have found some mention of tuning JFS, first was check the type of filesystem mount, if CIO enabled disable it. Then set 'ioo -p -o j2_dynamicBufferPreallocation=64'. I've also seen mention that j2_nPagesPerWriteBehindCluster should be changed from the default 32 to zero I have some ideas of things I might like to try and see if they made a difference, setting the  "/usr/sbin/syncd 60 > /dev/null 2>&1 &" defa

Have a quick question. In JED, what is the hot key to enter a TM (char 251) into a record? The VM and SVM are clearly documented. In Universe in ED i would just go into Up Arrow Mode  and change it there, but does not seem Up Arrow Mode is supported in ED on Jbase. Editing this in HEX does not seem supportable and I'd rather not have to create a user interface for this for a super user. I do see it's supported through RAISE() and LOWER(), so it should be there. Also see that @TM is supported. ------------------------------Greg MotterRocket Forum Shared Account------------------------------

I have a client that runs a 24/7 application on UniVerse (11.3.2).  They are conscientious about keeping their files well sized.  Several years ago they tried the CONCURRENT option on RESIZE and got badly burned when they ended up with corrupted files and lost data.  They have been very gun shy about using CONCURRENT since then.  Has anyone resized UniVerse files with the CONCURRENT option recently?  Is it stable now or is it still a crap shoot on the end result?  If you use it, what is the performance impact?------------------------------Steve Murray-WolfOwnerRocket Forum Shared AccountFirestone CO US------------------------------

Hello! what is the procedures to open a ticket on stand by?  We are upgrading Unidata AIX from a server to the cloud  for a critical software over a weekend and want to be assured that there will be support incase we have issues.  Thanks------------------------------Peter GonzalezSt. Louis, MO US------------------------------

Rocket MV BASIC for VS Code 2.2.0 features highly stable and performance debugging Yunpu Zhao September 26, 2026 We're excited to introduce everyone to v 2.2.0 of Rocket MV BASIC for Visual Studio Code. We've added a new debugging feature that significantly improves performance and stability using gRPC and related technologies. (Currently compatible only with UniVerse 11.4.1's Windows / Linux versions.) Implementation of Previous Debugging In v1.6.0, we initially introduced debugging. This feature communicated with the MV Server using UOJ+UniRpc. We sent debugging command-line instructions (CLI) to the MV Server and retrieved the results as strings, which represented the execution outcome of the CLI instructions. Decoding these strings was necessary to obtain the required debugging data but process had a lot of room for improvement. Introducing gRPC gRPC is a modern open-source remote procedure call (RPC) framework that efficiently connects services within and outside data centers, o

We have a number of PHP pages that access QM on another server.   Our response time is slow by my standards. we have added some pretty significant logging to our process. We know the pageload time in PHP, we know the time for the function call to QM, and we know the QM response time. We getting some variability in response time as well with no patter that we can see. Our OpenQM server is in Azure and running on W2019. Our web server is on a private server running Apach and linux. we are using our url name and port 8280 as normal http://web.xyz.com:8280/api/ we are seeing times of 1.723 seconds to get the function and pageload in PHP. The QM side takes 8ms . we have been looking that the flush time on MVCONNECT, this seems to make no appreciable difference. we are off checking to make sure nothing on the windows server is grabbing this, such as virus checker or something. we down to internet time. Looking for suggestions on best practices.  Should we make a private tunnel from linux to

Hi Again, I am trying to change the background color of an ITEM , it has FORGROUND and BACKGROUND options in its PROPERTIES when looked at in ACCUTERM. So I am assuming that they can be changed on the "fly" durring use of the form. Here is what I have tried so far           CALL ATGUISETPROP(GUIAPP,GUIFRM,'COMBCUST',GPITEMS,0,0,CUST.LIST,GUIERRORS,GUISTATE)*         RGBCOLOR = 102 + 255*256 + 102*65536*         RGBCOLOR = "Green"*         RGBCOLOR = 102:@SVM:255:@SVM:102         RGBCOLOR = "102,255,102"         CALL ATGUISETITEMPROP(GUIAPP,GUIFRM,'COMBCUST',GPBACKCOLOR,0,0,RGBCOLOR,GUIERRORS,GUISTATE)         IF GUIERRORS<1> >=2 THEN GOTO GUI.ERROR         CALL ATGUISHOW(GUIAPP,GUIFRM,"COMBCUST","",GUIERRORS,GUISTATE)         CALL ATGUIACTIVATE(GUIAPP,GUIFRM,'COMBCUST',GUIERRORS,GUISTATE)         IF GUIERRORS<1> >=2 THEN GOTO GUI.ERROR         It always aborts , as you can see I have tried the RGB raw number, a generic name as used in the Properties drop down, the num

Hi,  am now using Accuterm well but am stumped by the the resulting functionality of the  Combo Box. Lets say the combo Box is waiting for a request and the user enters a Name (as requested)   BAXTER  I then search the Customers file and find 21. When I have created a list and loaded it, how do I make the list shown on the screen so that the user knows that their search request has a result. I realise that the user could simply press the "down arrow" but I would prefer to show them the first 8 items to indicate that the selection is ready for picking  I hope this makes sense. Blessings Chris Baxter------------------------------Chris BAXTERMDCB SoftIPSWICH GB------------------------------

Any U2 Basic program utility available to import JSON object into a dynamic array or Name-Value pair? I expect the U2 program to accept a JSON object as an input, and a list of Variable names to parsed from the JSON object. The output could be a name-value pair.------------------------------suresh anbilOwnerOHM Systems IncCincinnati OH US------------------------------

Has anyone else experienced this?   Since the move to UniData 8.2.4 Build 3003, I cannot use the "BL"  (Break at Line) in the UniBASIC Debugger without getting a mini dump for my troubles. I am unclear if I've just gotten really unlucky, or if something is not working as expected in this build. I have the team I work with opening a case, but wanted to see if this is something that is just my miserable luck, or if something is not quite right. It pretty consistently tells me I have an 'Access violation.  Attempted to 'read from address 0xFFFFFFFF'  ------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

This was highlighted to me by the Director of Development as a feature when we were shipping UniVerse 4.4.4. The command syntax is: verb [DICT] filename [records | FROM list#] … where verb is among 18 options including CHECKSUM, COUNT, and LIST. Do we care if the file name can be almost anywhere in the query? Do we want to advertise this feature in the documentation? Should we just follow the documentation which wants [DICT] filename first? Is this for compatibility with some legacy multivalue environment? Is this capability simply a side effect of the lex/parse implementation? Does anyone do things like the following?: LIST DICT F1 VOC (Split DICT and filename) LIST F1 DICT MD (Filename after fields) LIST VOC DICT (At least this does NOT work – if DICT is not a dictionary field) Thoughts? ------------------------------Mark A BaldridgePrincipal ConsultantThought MirrorNacogdoches, Texas United States------------------------------

As a discussion starter, I'd like to throw out a few wish list items that would be helpful in our environment and, I assume, might be helpful to others:1. Block commentsThere are times when it would be very helpful to have the capability to use block comments. In BASIC programs, using a 'IFDEF()' sort of works but this capability should be available in all source code environments, e.g., BASIC programs, procs, paragraphs, etc. This would allow using markdown for documentation and would simplify program maintenance and management.2. Default text file typeFiles using Type 1 and Type 19 are intended for storing text data. Type 1 is a throwback (way back) to old Pick capabilities and, on current systems (Linux or other) is just another piece of tedium to deal with. I would like to suggest a configuration item that would indicate the type of file to use for standard text files. So, if a new account is created, those system files (like &SAVEDLISTS&) would be created as Type 19, rathe