Rocket® U2 | UniVerse & UniData®

The code below suddenly stopped working. I perform the same request with a curl statement and it works.  does someone see something I should change or add to my request or is universe 11.xx not up to date with modern security? 051:       HTTP.METHOD    = "POST"052:       OUT.URL        = TOKEN.URL:TOKEN.ENDPOINT053:       VERSION.CODE   = setHTTPDefault('VERSION','1.1')054:       CTX.TYPE       = ''055:       MY.RTN.CODE    = createSecurityContext(MY.CONTEXT, CTX.TYPE)056:       CREATE.CODE    = createSecureRequest(OUT.URL,HTTP.METHOD,HANDLE,MY.CONTEXT)057:       RET1 = setRequestHeader(HANDLE,'Accept','*/*')058:       RET1 = setRequestHeader(HANDLE,"content-type","application/x-www-form-urlencoded")059:       RET1 = setRequestHeader(HANDLE,'HTTP Protocol','HTTP/1.1')060:       REQUEST.OUT  = 'grant_type=password'061:       REQUEST.OUT:= '&username=':USERNAME062:       REQUEST.OUT:= "&password=":USERPW063: *064:       stat           = submitRequest(HANDLE,30000,REQUEST.OUT,RESP

Hi everyone, been a while since I visited and even longer since I shared.We are moving from SQL file triggers to the IDX file triggers and ran into a small issue where we have a trigger on the DICT and a trigger on the DATA levels of the same file.Getting the DATA level trigger working is simple but how to get the trigger in the DICT working?Not sure if anyone has done this before but in short the answer is you need two dictionary items: INDEX.ITYPE for the data level and D_INDEX.ITYPE for the dictionary level. To build the index on D_INDEX.ITYPE you need to use the “USING” clause in the CREATE.INDEX command:CREATE.INDEX DICT FILENAME D_INDEX.ITYPE USING DICT FILENAME NO.NULLSThe trigger will now fire when a record is added/deleted/modified in DICT FILENAME.

Universe 11.3.1,  AIX 7200-05-11-2546We noticed when comparing very large numbers they don’t correctly evaluate to not equal. Specifically, if two variables are over 17 characters in length and they don’t match correctly. See the below sample program and its output. The (X NE Y) does not evaluate to true until the length of the strings are 17 characters even though the variables are never equal. Does anyone know what is causing this to happen?  X = '0587634906513946593645'Y = '0587634906513946593646' FOR Z = 1 TO 8  CRT X, Y, (X NE Y),LEN(X)  STRLN = LEN(X)  X = RIGHT(X,STRLN-1)  Y = RIGHT(Y,STRLN-1)NEXT ZOutput:0587634906513946593645        0587634906513946593646        0         22        587634906513946593645         587634906513946593646         0         21        87634906513946593645          87634906513946593646          0         20        7634906513946593645 7634906513946593646 0         19                            634906513946593645  634906513946593646  0         18        

A recent client asked how we produce different type documents within in the Universe/Unidata database. There is no Rocket Software product that does that I am aware of. Using a Eclipse open-source product called BIRT with a Universe/Unidata ODA interface you can produce all of those types and more. So, am I right about no Rocket Software product that creates reports in different formats?

I can’t remember the initiation command to use instead of “uv” to enable multiple concurrent sessions.  Can someone help me?Thanks, Dale

Greetings, Rocketeers!How can I accomplish moving BASIC source code from a production environment to a development environment?…THX!~Doc

Hi everyone, Does anyone know how to make the "Universe Telnet Service" that runs on our IBS Application server, to only use 128bitblock Ciphers, and disable the other lower 64bit block ciphers? The service listens on port 992. The problem is that our Qualys VUN scanning tool is picking up that port 992 is a security risk againstBirthday attacks against TLS ciphers with 64bit block size vulnerability (Sweet32) and goes on to say"Disable and stop using DES, 3DES, IDEA or RC2 ciphers.  We believe that the "Universe Telnet Service" uses OpenSSL that offers out these lower level ciphers, but we have no idea how to to best address this sothat the only ciphers used are 128-bit or higher ciphers. We are waiting on our third party support to get back to us as they have opened a ticket today. Current version of OpenSSL is OpenSSL 1.0.2m-fips  2 Nov 2017, though "Programs and Features" is saying OpenSSL 1.1.1k (64-bit) was installed on March 2021. Universe is 12.1.1 is installed. Thanks in advan

Michael Rajkowski March 29, 2017 Rocket Software has added support for the Python development language to Rocket® UniVerse 11.3.1 and Rocket® UniData 8.2, on Linux and Windows only. Python will also be added to Rocket® D3 in the second half of 2017. Adding Python support gives experienced and new MultiValue developers the opportunity to code in one of the most popular development languages available today. To help developers get started Rocket created a Python community page that hosts links to code samples, documentation and lots more. PYTHON IN MULTIVALUE – THE BASICS Python now sits at the same level as the other access method used by the MultiValue developer. Our MultiValue Python module consists of two parts. The main access point for the Python developer is the u2py module, which is Python code. The u2py module calls a module written in C. Since both Python and the U2 databases are written in C, it is compatible and can be embedded into the database. The entire box represents

Is anyone using Python within UniVerse to format data (.xlsx) that will be used as an email attachment?

We are validating our software package will run on UV version 14.2.1 and noticed the TCL UNLOCK command has been changed since version 11.3.1. UNLOCK ALL is no longer valid and the command will not unlock some record locks. For example: UNLOCK PID 9312 FILE D:\IBM\ACCOUNTS\BRIDGETON\SFH.CONTROL RECORD SFH@BRIDGETON Does not release the lock: 06 LIST.READU DETAILSActive Locks:Device.... Inode.... FileName. UsrNo Pid.... LoginId ItemId... M LockTime.......1680857659 562949953428398 D:\IBM\ACCOUNTS\DDICLOUD\SFH.CONTROL -26 7636 ddiadmin SFH.CLEANUP@DDICLOUD X Wed Jun 17 23:18:54 20261680857659 562949953433153 D:\IBM\ACCOUNTS\BRIDGETON\SFH.CONTROL -24 9312 ddiadmin SFH@BRIDGETON X Thu Jun 18 14:14:34 2026 Any insights on:How to release all locks? Why the SFH@BRIDGETON lock is not released? Any other UNLOCK gotchas in version 14.2.1 v 11.3.1?Thanks in advance.

New features. Live demos. Practical insights. Rocket® UniData 8.4.1 is here – and it brings powerful updates designed to modernize your applications, improve observability, strengthen security, and boost developer productivity.Watch this customer enablement webinar to get a clear, practical walkthrough of what’s new in UniData 8.4.1, followed by live demonstrations of OpenTelemetry and BASIC enhancements so you can see the latest capabilities in action.UniData 8.4.1 HighlightsOpenTelemetry integration (Phase 1) for deeper observability BASIC enhancements: Try/Catch, dynamic objects & native JSON UniData Performance Monitoring (udtpm) now on Windows Compiler directives for easier multi-version code management Improved replication with sequential I/O Updated security & platforms: OpenSSL 3.5, Python 3.13Live demosOpenTelemetry observability in action BASIC extensions for more efficient development

In MvBase, there was a TCL command called “FIND”. This was a great utility. It allowed you locate a string in every record in the specific file.It would then give the user the chance to save the found record ID’s to a select list Is there are equivalent function or add-on in UniVerse?

I am looking to move our clients over to UniVerse, but I am curious to know if UniVerse is fully multicore/multithreaded? 

I’m trying to use CONVERT.SQL on an a very old Unidata system on HPUX. I’m getting this error message. Can someone tell me what may have been removed from the VOC years ago?  Other SQL commands seem to be OK, for now.  :CONVERT.SQL PETERdefault name length 30 is used'__V__VIEW' does not exist in VOC file.Open view file error

We run GUIDEs every night around 1:00 AM.  On Sunday, one of our files, SODEL, suddenly had thousands of errors on an indexed field (SCHED.DT).  I doubt there were any changes to the file since Friday and we had no errors before.  I pulled up several of the noted records in the editor, went into up-arrow mode, but did not see any errors, control characters, etc. in the data.In a copy of our LIVE account, called MIDNIGHT (a copy of LIVE created ad midnight), and typecat GUIDE_XERROR.LIS | morewe see this:This goes on and on, possibly for all 500K records.  The GUIDE_XERROR.LIS file is huge, over 22 megs.From within UniData, if I type “SSELECT SODEL BY F4”, I get:I get this for a bunch of records (maybe every record).  If I edit the SODELs, none have any escape characters, so what is this error trying to tell me?This is followed by: The keys to the SODEL all look correct.I build a new file called SODEL.JRI and from the command line, copied all the records to this new file.  It has the sa

New Features. Live Demos. Practical Insights.Rocket® UniData 8.4.1 is here and it brings powerful updates designed to modernize your applications, improve observability, strengthen security, and boost developer productivity.Join this customer enablement webinar to get a clear, practical walkthrough of what’s new in UniData 8.4.1, followed by live demonstrations of OpenTelemetry and BASIC enhancements so you can see the latest capabilities in action. What you’ll learnUniData 8.4.1 highlights• OpenTelemetry integration (Phase 1) for deeper observability• BASIC enhancements: Try/Catch, dynamic objects & native JSON• UniData Performance Monitoring (udtpm) now on Windows• Compiler directives for easier multi-version code management• Improved replication with sequential I/O• Updated security & platforms: OpenSSL 3.5, Python 3.13Live demos• OpenTelemetry observability in action• BASIC extensions for more efficient development Why attend?This webinar will help you:• Understand the full

Hi,Using VS Code and extension Rocket MV BASIC 2.7.0 is connecting 100% to my UniData account version 8.3. But as soon as I go to any version higher then Rocket MV BASIC 2.7.0 I get a error Account Not Found from MV BASIC. The config files have not change between the versions. Is there anything I need to do with the UniData Account to support a higher version of Rocket MV BASIC?

TBW&W (throw back Wednesday & wondering)Just a “gee whiz” question for any/all, is there a PICK DBMS that continues to use SYSPROG? NEWACC?THX!Doc

Greetings all!Looking for anyone who can weigh in on their experience with Rocket’s Aldon LM?  Currently on Universe 11, needing source control and just learning of LM’s existence.Many THX!~Doc 

We are thrilled to announce the release of Rocket® UniData 8.4.1 on May 20, 2026 a feature rich release designed to boost observability, application modernization, performance monitoring, security, and replication reliability.Whether you’re a developer, administrator, or part of an ops team, this release delivers meaningful improvements that help you build smarter, run faster, and operate with confidence.Let’s explore what’s new!Observability Takes Off: OpenTelemetry (Phase 1)Gain deeper, actionable insights into UniData workloads with the initial release of OpenTelemetry (OTEL) support. Delivering immediate observability value today and establishing a solid foundation for future monitoring and observability enhancements, including:A new OTEL licensing flag to enable OpenTelemetry functionality. Updates to the confprod and confcmd commands for the OTEL flag.BASIC Language EnhancementsTry/Catch Error HandlingThis new feature paths the way in providing modern and resilient control of err

We are in the process of upgrading from Unidata 8.2.4 to 8.3.2.  While the OpenSSL bundled with Unidata has upgraded from v1 to v3 as part of this upgrade, the OpenSSL 3 is still showing vulnerabilities as part  of our vulnerability scanningOur security team are asking if its possible for Unidata to use the version of OpenSSL thats installed as part of the Red Hat Linux and kept up to date via patching.Is this possible?  Is it a god/bad idea?  Is there a clear process for doing this?

UOPY Example - Working with JSON  Making the connection The following code is a simple example to connect to a local U2 Database. In this example I am connecting to UniData, but the code would work the same against UniVerse, the only thing you would need to modify is the server and account settings. In [1]: import uopy import getpass user = input("Enter user name? ") passwd = getpass.getpass("Enter Password? ") def makeconnection(user, password): config = { 'user': user, 'password': passwd, 'service': 'udcs', 'account': 'C:\\\\U2\\\\ud82\\\\XDEMO', 'encoding': 'GB18030', 'pooling_on': 'False' } thissession = uopy.connect(**config) return thissession session = makeconnection(user, passwd) print(str(session)) Enter user name? mrajkowski Enter Password? ········ <uopy._session.Session object {'host': 'localhost', 'account': 'C:\\\\U2\\\\ud82\\\\XDEMO', 'por

I’m attempting to load Universe 10.2 (yeah, I know it’s old) on a Windows 11 Pro platform.  I’m getting a load error: “Could not load UniVerse DLL D:\IBM\UV\BIN\universe.dll”.  Has anyone had any success in loading this releases on Windows 11, or have found a work around for it? (beside upgrading..lol)Thank you all in advance..Mark Warner

We get asked every now and then where to get the U2 client software.  These include:U2 Clients ODBC, JDBC, UOJ and .NET drivers and associated tools Visual Schema Generator SSL Setup Tool Certificate Management Tool Dynamic Connect Intercall U2 DBTools U2 Basic Developer Toolkit U2 EDA Replication Configuration Tool U2 EDA Schema Manager U2 Extensible Administration Tool (XAdmin) U2 Metadata Manager U2 RESTful Web Services Developer U2 XML/DB Mapping Tool These two packages are all available for public download from RBC | Rocket Software - just choose : Resources  Product Availability Choose the Product and 'Search',  either for U2 DBTools or U2 Clients (these will always show as for Windows, though the JAVA clients are multi-platform) Use the 'Product' link under the 'Downloads' column for the version required - this will usually be the latest version. You will now have options to download the Product - which includes the Documentation - or the Documentation only, All Documentat

i will have to upgrade a universe server and a unidata server in the coming year. i thought why are we running both. when i upgrade the unidata server should i convert it to universe. is it more work than doing the upgrade itself. if so how much more work.