Rocket® U2 | UniVerse & UniData®

Creating a purge program.  First make a past on a stat file that has cust# and date to select appropriate records to purge into a “to purge” array (INSERT “AR”).Then, read through main file, using a locate on the array to determine if it was one selected.  If so, delete it.Issue is that the main file are from 1-5 records whose IDs begin with the cust#.  This file does not have a date to be used for purging.  The main file has almost 5M records.  The “to purge” array has 50k-150k cust#s in it.  The first pass to create the array from the stat file only takes 30 seconds even with 3M+ records.  However, reading through the main file, using a LOCATE (“AR”) is really slow.I would think that locating in the array would be faster than doing one pass on the main file and doing 4M+ reads on the stat file.   So, I was wondering if anyone had a better idea that would speed up the process.Universe v11.3.1.6022 running on AIX 7.2

Your Rocket® MultiValue Modernization Journey Starts with MVISWhether you’re just mapping your modernization journey or already well underway, Rocket® MultiValue Integration Server (MVIS) is the bridge to take your Rocket® UniVerse– or Rocket® UniData®–based applications further, faster, and more efficiently.Top five things you may not know about MVISHow many of these facts surprise you?We released MVIS in June 2019 to empower MultiValue customers like you. MVIS is available for newer versions of Rocket UniVerse and Rocket UniData. Check the Product Availability Matrix (PAM) to see if it supports your environment. MVIS is included with your maintenance agreement. If your maintenance is current, you can order and download MVIS at no additional cost on RBC. Connection pools power MVIS in your production environment. See how connection pools deliver high performance in our short infographic. Your peers already use MVIS for modernization. MVIS is a proven way to bring existing MultiValue a

Hello, it is me again fighting UOPY.  I need to push a big file, and after multiple testing, I found that I could not push a file bigger than 128K. The process hangs there forever. Is this a Unidata limitation or a UOPY limitation? Is there a way to change this limit? Here is my code: def pushFile(dname,fname):   f = open(dname+'/'+fname,'rb')   lines = f.read()   f.close()   print('done reading')   # print(lines)   udfile = uopy.File(dname,session=_session)   udfile.write(fname,lines)   udfile.close()   print("file uploaded") Any help is greatly appreciated.------------------------------Alejandro GarciaSoftware Engineer ManagerF W Davison and Company Inc. DBA PrismHRMA US------------------------------

Hello all!I’m adding variable data type protection to a subroutine label in a program I’m working on. However, I’m experiencing unexpected behavior when using the `DESCRINFO` function.Here is an example:* Set up some stuff here...IF RUN.MODE = "AUDIT" THEN EQUATE NUM.REPORTS TO 10 DIM REPORT.COUNTS(NUM.REPORTS) MAT REPORT.COUNTS = 0 GOSUB PREPARE.UTILITY.REPORTSENDLOOP * Do stuff here...UNTIL IS.DONE * Do other stuff here, maybe write to a report...REPEATIF RUN.MODE = "AUDIT" THEN GOSUB CLOSE.UTILITY.REPORTSEND* Other code here...STOPPREPARE.UTILITY.REPORTS: * Prepare reports, calling SETPTR and HEADING/FOOTING... RETURN; * Internal CLOSE.UTILITY.REPORTS: * HERE LIES MY ISSUE; THIS RETURNS 1 (INTEGER) BECAUSE OF THE 'MAT' ABOVE IF DESCRINFO(1, REPORT.COUNTS) # 5 THEN RETURN END * Close reports, print 'no data found' message if count = 0... RETURN; * Internal* Some other subroutines here...END; *ProgramHere is another example, simplified:DIM ARR.1(10)D

Hello! I’m relatively new to UniVerse and Multi-valued databases, so my experience with BASIC is limited.I was writing a program with subroutine calls that I wanted to abstract via ‘@<var>’. This program had a “create output file data line” subroutine and a “finalize output file” subroutine. When I wrote these local subroutines (explicitly defined, not subroutine labels), I encountered an error where, when calling with ‘@’, only the first locally-defined subroutine would be found; the other subroutine would cause a runtime error, unable to be located. It was not found locally, and so the object database file (.O) was being searched, instead.For example:* ...IS.DONE = @FALSE* Main loopLOOP READNEXT FILE.NAME ELSE IS.DONE = @TRUE ENDUNTIL IS.DONE * ... OUPUT.FILE = "" PREPARE.DATA.SUBR = "" FINALIZE.FILE.SUBR = "" * case 1 BEGIN CASE CASE FILE.TYPE = TYPE.1 PREPARE.DATA.SUBR = "DO.SOMETHING.1" FINALIZE.FILE.SUBR = "END.FILE.1" CASE FILE.TYPE = TYP

I am receiving JSON from a third party and it contains a null value like below.  I call UDOGETPROPERTY for line_item_id and when I try to reference the return value I get Improper data type and my process terminates. How do I detect for the null value in the return value?  

While deleting file in UniVerse using TCL - I get Unable to open "RC.OE.UPD.COGS.LOG" file.”I verified file exists…Here’s o/p from TCL LIST VOC 06:32:11am  30 Nov 2025  PAGE    1NAME.......... TYPE DESC..........................RC.OE.UPD.COGS F    F.LOG1 records listed. ;CT VOC RC.OE.UPD.COGS.LOG                                                                   RC.OE.UPD.COGS.LOG                     0001 F                                      0002 RC.OE.UPD.COGS.LOG                     0003 D_RC.OE.UPD.COGS.LOG                  ;DELETE.FILE DATA RC.OE.UPD.COGS.LOG        Unable to Open/Delete : RC.OE.UPD.COGS.LOG  ;SELECT RC.OE.UPD.COGS.LOG                  Unable to open "RC.OE.UPD.COGS.LOG" file.   ;                                            

Is there a limit to the value length in a select statement?When I run:   SELECT OP.MANIFESTED.HIST WITH TRACK.NBR = "420015859261290986498138210077"I get multiple rows back with TRACK.NBR different from above. For example:420015859261290986498136795170420015859261290986498151260165420015859261290986498151221500Is there a limit to how many characters it’s comparing in the select value?Other explanations?I removed the indexes off a copy of the file and I still get the same result, so it’s not a bad index issue.

With the shift from simple LLMs to transformative Agentic AI, we know an AI Revolution is coming, bringing significant changes in the near future.But a new question must be asked: Is your MV application ready to join the AI Revolution?MV application modernization is the key to leveraging AI, but when you really try to modernize, you will most likely run into a critical architectural roadblock that stalls progress.Find out what the real MV application modernization challenge is and, more importantly, how to overcome it:Watch the full video here: Is Your MultiValue App Ready to Join the AI Revolution?We invite you to watch, comment, and share your thoughts on the MV modernization journey!

The Recoverable File System (UVRFS) re-introduced in UniVerse 14.2.1 is an optional add-on feature that can be purchased through RBC for Server and Enterprise Editions of UniVerse. How to Order UVRFS via RBC:UVRFS will automatically appear in the list of add-ons in Rocket Business Connect (RBC). The user count for UVRFS will match your UniVerse license user count. Simply check the box to add UVRFS to your license. RBC will automatically apply your contracted rate.For further details on UniVerse optional features please refer to the MV Handbook, available from the RBC documentation page.

helloReally grateful for any assistance, I have been stuck on this for about 1 week now.I have SBXA working with unidata 8.1 sb+ 6.5 on windows 2012R2I have replatformed application to Windows 2022 unidata 8.3 sb+ 6.6.3i have Unidata server and separate commincation server. if i run :C:\Users\<mylogin>\AppData\Local\Apps\2.0\Y2N21CTT.YLM\D6JBB313.34V\sbxa..tion_74d57911d24a77ad_0006.0006_359984abce80fb3f\SBXAWinFxWindow.exeas administrator, intial connection fails: Unable to connect to SB/XAFailed to connect to the application because connecting to the account 'F:\AVANTE9\FLODATA\LIVE\LIVE.DATA.533' on the Application Server with address 'localhost' using U2 User ID 'IUSER\XXX' from the Communications Server failed.Details:[Rocket U2][UCINET - UNIRPC][ErrorCode=81016] The connection was refused as the RPC daemon is not runningSocket Exception caught and WIN32 API Error Code:10061 and Error Message:No connection could be made because the target machine actively refused it 127.0.0.

The Rocket MV team is pleased to announce the release of Rocket ® UniVerse 14.2.1 on 5th November 2025.Rocket® UniVerse 14.2.1 builds on a proven foundation to deliver even greater resilience, flexibility, and modernization. With enhanced high availability and disaster recovery features, this release ensures your business stays online and agile—no matter what.Built for Resilience: Uptime You Can Count OnProtect your system with the Shared Structure Recovery Framework RFSThe enhanced Recoverable File System (RFS) in UniVerse 14.2.1 gives you full control; configure it your way to align with your unique environment. Toggle RFS on or off using the RFS_MODE uvconfig parameter. Please note: UVRFS is an optional add-on feature that can be purchased through RBC.Secure your most critical files with Protected File ConfigurationOnce RFS_MODE is enabled, use a dedicated configuration file to define which files to protect, giving you more control over data protection.When RFS is enabled and files

Hi community,Plateforme : windows server 2016, uv 14.1.1.1002, Over the past few days, we’ve been experiencing random errors on uv static files. The same error messages appear repeatedly — expected blink 0x0 or 0x10000.These errors can occur up to ten times a day and affect various files (e.g., VOC, XXPROCESS, XXPPP, etc.), the most strange is these files are mainly used for read.... To resolve them temporarily, we use fixtool -fix (at boot uv, else the files are locked). Does anybody have any idea what could be causing this?We’ve already checked our antivirus, but the problem persists.Any insights or suggestions would be greatly appreciated ;) With kind regards Manu

Follow the link below to the innovation forum. https://community.rocketsoftware.com/multivalue-innovation-library-home-11/expanding-on-universe-and-unidata-esearch-tool-to-use-python-based-regex-search-27332

Greetings all! Can someone please direct me to documentation to dictionaries in UniVerse and what each attribute is used for? Many THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Hi everyone,  Just a quick reminder: starting tomorrow, Rocket Forum will be temporarily locked as we roll out an exciting transformation. We can't wait to welcome you back to a refreshed, more intuitive, and inspiring community experience on October 23rd. Here's what to expect: The Forum will switch to read-only mode from October 15th to October 23rd. You'll still be able to browse existing content, but posting, commenting, and liking will be paused during this time. After the improvement work wraps up on October 23rd, you'll gain access to the new, improved Rocket Forum, featuring simpler navigation, exclusive insights, and even more recognition for your participation. Important: Upon your first log in after October 23rd, you'll be prompted to reset your password. For more information about the changes ahead, please visit this page. If you have any questions, feel free to reach us at community@rocketsoftware.com. Thank you for being a vital part of our community on Rocket Forum.

Hi All, Hopefully this is a quick one, that I did not want to trouble Rocket support with. I know that UV11.3.5 is certified for Windows Server 2019, we aim to get as many of our customers on Windows onto Server 2022. However, we may have some who want to stay on 2019. To your collective knowledge are there any issues in sticking with 2019 for UV11.3.5? Many thanks.

Hi, I can see online documentation refers to The EDA SQL Server driver supports SQL Server 2014 and greater. Is there a driver to support SQL Azure. Thanks------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

Hi Running uv 14.1.1 on Windows, we are waiting to receive the patch 1002 Hotfix. Meanwhile, how can we restart uvcleanupd.exe without restarting uv himself !  If I start it from a console, it works but not as a background process. Thanks for any sugg.  Manu

Do we have a version of U2 Toolkit for .NET Developer with U2.Data.Client that supports any .NET 6 or preferably .NET 8 applications? I'm struggling to find information on it.

We have an app that is using the U2.Data.Client (version 2.2.2) to call a subroutine and the app is using transactions for an orchestrated business flow. Part of this orchestration is calling a subroutine and I need to know if that subroutine is, or has a way to, operate within the transaction of the U2.Data.Client. If so, how would I get that to work?

Hey folks, Sorry for the continued PROC questions but the owner of our company loves them...groan! Question for y'all, is there anyway to create a unique list ID within PROC. like "SAVE-LIST LIST.NAME.PORT#" or ...? THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

HelloI am testing the new-ish 'DT' conversion code in UV 11.3.5 (on RHEL8) and am having no success getting it to do what seems like simple conversions. I put together the following test code to give it a go: -- * Testing the new DT conversion code sys.VAL     = system(99)now.VAL     = now()local.VAL   = datetimel()utc.VAL     = datetimez() crt "NLS status : ":oconv(system(100),"S;'On';'Off'")crt "system(99) : ":sys.VALcrt "now()      : ":now.VALcrt "local      : ":local.VALcrt "utc        : ":utc.VAL lst.TESTS = ''lst.TESTS<-1> = "O": @VM: sys.VAL: @VM: "DT"lst.TESTS<-1> = "O": @VM: sys.VAL: @VM: "dt"lst.TESTS<-1> = "O": @VM: now.VAL: @VM: "DT"lst.TESTS<-1> = "O": @VM: now.VAL: @VM: "dt"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "DT"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "dt"lst.TESTS<-1> = "I": @VM: utc.VAL: @VM: "DTIS"lst.TESTS<-1> = "I": @VM: utc.VAL: @VM: "dtis"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "DT"lst.TESTS<-1