Rocket® U2 | UniVerse & UniData®

Paul Chang June 20, 2018 External Database Access (EDA) enables you to convert data stored in a Rocket UniVerse and UniData database to a first normal form (1NF) database, such as Microsoft SQL Server, then access that data using existing UniVerse BASIC programs, RetrieVe, or UniData/UniVerse SQL. For UniVerse running on a Linux platform, previously you had to purchase an ODBC driver to work with the EDA solution. Now, Microsoft provides you with ODBC Driver 17 for SQL Server on all Linux platforms. It is free and easy to install and use. UniVerse supports it starting with UV 11.3.1.6018 or later. In this blog, you will learn how to work with the UniVerse EDA solution with Microsoft ODBC Driver 17 for SQL Server on Linux. I’ll cover th

Michael Rajkowski April 12, 2017 In part one of the series “Python for the Rocket MultiValue Developer – Part 1 of 3 – Introduction” we discussed the architecture of the Python / MultiValue solution including the fact that the MultiValue and Python code both run in the same process. In this section, you’ll learn how Python interacts with the MultiValue Application Platform, through the use of the u2py module. THE U2PY MODULE The u2py module for Python allows developers to interact with the MultiValue Application Platform in the following ways: run U2 ECL/T

Emma Breslin April 30, 2024 The Rocket MV team is pleased to announce the release of R

Paul Chang September 18, 2019 Overview External Database Access (EDA) enables you to convert data stored in a Rocket UniVerse or UniData database to a first normal form (1NF) database, such as SQL Server, Oracle and DB2 Server. You can then access that data using existing UniVerseBASIC programs, RetrieVe, or UniData/UniVerse SQL. UniVerse 12.1.1 supports a new EDA solution against MySQL Server. In this blog, you will learn how to work with the UniVerse EDA solution on Windows or Linux against MySQL server 5.6. I will provide sample steps to install &

Jonathan Smith February 6, 2019 Part 1 of 3 This blog post offers best practices related to implementing and using Replication, as part of a High Availability/Disaster Recovery (HA/DR) strategy. In Part 1, I’ll focus on preparation. I make no apology for this: U2 Replication is NOT an administration free option. In the event of a failure, your organization will absolutely depend on Replication. This blog series will help you to: Avoid common pitfalls that can be encountered in U2 Replication Understand the methods and strategies that have worked well for others Understand the tools that are available for monitoring and tuning of replication Preparation

Emma Breslin March 5, 2024 The Rocket MV team is pleased to announce the release of UniData 8.3.1, U2 Common Clients 5.4.1, and MV BASIC for Visual Studio Code (VS Code) 2.4.0 on February 26th, 2024. Rocket® UniData 8.3.1 UniData 8.3.1 HA/DR enhancements and bug fixes help you manage your replication environment more effectively. We’ve added a new script so you can stop and restart the repmanager, eliminating the requirement to restart UniData if the repmanager becomes unresponsive. We’ve enhanced the "invalid log sequence" message to include the actual and expected LSN number, which will assist you when debugging. We’ve added a skip option to the ud_rep

Paul Chang June 12, 2019 Using multiple unirpcd daemons to balance client requests can have a positive impact on performance. Also, using a different port for a specific application simplifies management. And, if users are on a newer version of UniData or UniVerse, they might want to use a different port specifically for a secure connection. On newer versions of UniDataand UniVerse, multiple Unirpcd Daemons with

Emma Breslin July 16, 2024 Rocket UniVerse 14.1.1 builds upon functionality implemented in version 11.4.1 and 12.2.1, making it the upgrade and modernization path for all customers on all prior versions. UniVerse 14 ensures business continuity and helps you manage your replication environment effectively with key HA/DR features. Replication is faster and more flexible with Field-Level Updates, since the entire record is no longer transmitted during u

Safwat Boulos January 24, 2019 We live in a fast-paced world where executives need real-time reports to make business decisions. Thus, users need information at their fingertips to deliver those reports. If your business-critical data lives in a UniDataor UniVerse MultiValue database, External Data Access (EDA) can help. What is EDA? EDA allows users to convert UniData and UniVerse nested relational data to First Normal Form (1NF), where it can reside in a SQL Server, DB2 or Oracle database, making the data easily accessible to standard tools such as Cr

Jonathan Smith March 13, 2019 UNIDATA HASHED FILES AND OVERFLOW In this first section we are going to discuss the two main types of UniData Hashed File (Static and Dynamic) and we’re going to discuss the two types of overflow that can occur in these files. The objective of file resizing is to minimize overflow as overflow is a performance overhead. 32-BIT V 64-BIT DYNAMIC HASHED FILES 32-Bit A UniDatastatic file or a sub-file of a dynamic file are limited to 2GB in size. Theoreti

Paul Chang July 18, 2018 External Database Access (EDA) enables you to convert data stored in Rocket UniVerse and Unidata databases to a first normal form (1NF) database, such as Microsoft SQL Server, then access that data using existing UniVerse BASIC programs, RetrieVe, or UniData/UniVerse SQL. For the UniVerse I-type fields, they can be mapped in many ways to SQL Server. This post will expand the mapping section of the External Database Access manual. Some additional mapping for I-type field dictionary items will be supported in UV 11.3.1.6018 or later version. In this post, you will learn how to work with the UniVerse EDA solution with I-type field dictionary items. I will provide you with sample steps for each of the different I-t

Hi All,We have a customer who are upgrading their hardware and OS to a Hyper-V environment running Windows 2022.Does anyone have any experience of running Unidata/Windows 2022 in a Hyper-V environment? Any issues we need to be aware of?Any comments/suggestions are much appreciated.Many thanks.Barry GreenCBS Software

Hey all- I've managed to locate the Unidata Dictionary, Commands, Basic and Administrator manuals. But, after years of being on other platforms, I'm really struggling with queries and report formatting in UniData. Operators like BY-EXP, ID.SUPP, HEADING, etc, keep popping into my recollection, but I'm still having a difficult time with syntax and order. The UniBasic manual helps to some extent, but I'm hoping there might be a more in-depth Manual (or training) specific to creating and formatting reports from ECL.thanks in advance for any assistance- Rich------------------------------Richard LucibellaDirectorRocket Forum Shared Account------------------------------

Hi everyone. Does anybody know the what the cost would be to upgrade to Universe from mvBase, if they have an active support contract for their mvBase installations? Any insight would be helpful. Best regards, Richard ------------------------------Richard OldsDirectorCalidore LtdUKrichard@calidore.comwww.caldiore.co.uk------------------------------

Does Rocket have any future plans for a uvnet comparable for uniData?

Hi, We are experiencing issues with our UniVerse session, where randomly the session gets frozen and becomes unresponsive. It's random and occurs once or twice per month, and the only solution we have is to restart UniVerse and it starts working. Has anyone experienced this issue or is there a fix around this. We are using Centos to host UniVerse 11.3.1 and this issue has started since November last year.   Below is a sample error message : kernel: uvapi_server[9052]: segfault at 0 ip 00007f7aa5a6b586 sp 00007fff414b15e8 error 4 in libc-2.17.so[7f7aa5938000+1b6000]kernel: uvapi_server[9045]: segfault at 0 ip 00007ff5418e0586 sp 00007ffc9b5592a8 error 4 in libc-2.17.so[7ff5417ad000+1b6000]  Thanks,------------------------------Amarendra RakeshBusiness System ManagerSMC CorporationSydney NSW AU------------------------------

Trying to get ODBC working.  Not sure how to address this error.  Help? 

Hello - I'm having trouble getting the symbol table to load while in the debugger - can someone tell me what I'm doing wrong please? ***There is no symbol table in '/usr/ud/sys/CTLG/m/MV.EMAIL.BUILD.TO.PC.AND.TO.SB'!EXEC BASIC MV.BP MV.EMAIL.BUILD.TO.PC.AND.TO.SB -Z2***Executing UNIDATA command:  BASIC MV.BP MV.EMAIL.BUILD.TO.PC.AND.TO.SB -Z2 Compiling Unibasic: /db1/ud1/PGM/MV.BP/MV.EMAIL.BUILD.TO.PC.AND.TO.SB in mode 'u'.compilation finished!Z MV.BP MV.EMAIL.BUILD.TO.PC.AND.TO.SB***There is no symbol table in '/usr/ud/sys/CTLG/m/MV.EMAIL.BUILD.TO.PC.AND.TO.SB'------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Hey, guys. new here. Programmed PICK and Unidata back in the late 80's / early 90's and I'm REALLY rusty. Can anyone tell me where to find a Dict Reference Guide?Thanks much- Rich------------------------------Richard LucibellaDirectorRocket Forum Shared Account------------------------------

This is probably an easy question for someone but I dont know the answer. I just switched to a new job and their wildcards seem to be prime like instead of PICK like...for instance - where I used to type 'SELECT VOC = "[KH]"' they are typing 'SELECT VOC WITH @ID LIKE "...KH..."' Can someone tell me if this is a UDT option? term type? some other setting that I can adjust? I can of course just get used to the new syntax but was wondering why it is different. Thank you Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Hi, Recently upgraded a site to Unidata 8.3.1 on Win Server 2022. Tried running Phantom LISTUSER at ECL Failed to start PHANTOM.Phantom execution failed. checked permissions user has full control What trouble shooting can anyone recommend. Thanks ------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

hi, May I introduce a suggestion to help the program runtime to check the type of a variable and not crash. There is already a function DESCRINFO(1,variable) which return the type of the variable ; so some type c.f. descrinfo() doc ref  on sellist, pyobject, udo, do, xdom, ... descrinfo() return -1 ...  I'll suggest to implement more descrinfo result value like 11=sellist, 12=pyobject, 13=udo, 14=do, 15=xdom, ... and by extension, if request_code = 2,  descrinfo return a DO with polymorph properties aka. metadata about the variable.  with kind regards------------------------------Manu Fernandes------------------------------

hi, when I try this : var = '' try var->$objecttype() catch e print 'error ':e->$tojson() endtry print 'finished' the error is not cached, the program terminate with echo bad self type: 2 and @SYSTEM.RETURN.CODE = -1  Same behavior with the $fromjson(), $tojson() ...  any idea ? ------------------------------Manu Fernandes------------------------------

on a READU the STATUS() function is returning the incorrect value for the userno if the record is locked but a phantom.  Instead of a negative number is returns the number without the minus sign.  Has this been addressed ? 0001:       OPEN '','INCIDENT' TO FILE THEN                                     0002:          READU X FROM FILE,'21333' LOCKED                                 0003:             PRINT STATUS()                                                0004:          END ELSE                                                         0005:          END                                                              0006:       END                                                                 0007: END                 ? LR                                                                           Account  File        UNO  PID   User       Record Id            Date  Time      -------------------- ---- ----- ---------- ----

My customer, UniVerse 13.5, is running on Nashville Metro Government's internal cloud.  The network security is so restrictive that it is difficult to get work done for the customer.  I have requested information from the "mypickcloud" website but have received no response.  Does anyone know if that cloud still exists and if so how to contact them.  If they do not exist does anyone have recomendations on other clouds where UniVerse could reside?  I have looked at AWS website and am buffaloed by the complexity of their options.  I would simply want to move my customer's system and data to a cloud server for day-to-day operations. Dale