Rocket® U2 | UniVerse & UniData®

I had a report of deleting some records from MYFILE was taking longer than it should. Below is the result of ANALYZE.FILE and HASH.HELP.  Can anyone provide some thoughts or advice about the size of MYFILE?   ANALYZE.FILE MYFILE File name= MYFILE File type= 18 File style and revision                 = 64BIT Revision 12 Number of groups in file (modulo)= 2368289 Separation= 4 Number of records= 7225458 Number of physical bytes= 6209269760 Number of data bytes= 3505627456   Average number of records per group= 3.0509 Average number of bytes per group= 1480.2363 Minimum number of records in a group= 0 Maximum number of records in a group= 13   Average number of bytes per record= 485.1772 Minimum number of bytes in a record= 104 Maximum number of bytes in a record= 55112   Average number of fields per record= 110.6418 Minimum number of fields per record= 40 Maximum number of fields per record= 286   Groups   25%     50%     75%    100%    125%    150%    175%    200%  full       288853  5

Hi all I'm trying to make sense of the encoding of strings coming and going between Basic and Python. Our Universe database stores its data using OEM encoding, so to pass data to Python we do a series of transformations inside Basic to convert them to UTF-8. Now I want to pass this OEM strings, as they are, directly into Python and do the conversion there, but I'm having some trouble. ALL.CHAR.STR='' ALL.CHAR.STR=ALL.CHAR.STR:CHAR(1):CHAR(2):CHAR(3):CHAR(4):CHAR(5):CHAR(6):CHAR(7):CHAR(8):CHAR(9):CHAR(10):CHAR(11):CHAR(12):CHAR(13):CHAR(14):CHAR(15) * rest of characters... ALL.CHAR.STR=ALL.CHAR.STR:CHAR(241):CHAR(242):CHAR(243):CHAR(244):CHAR(245):CHAR(246):CHAR(247):CHAR(248):CHAR(249):CHAR(250):CHAR(251):CHAR(252):CHAR(253):CHAR(254):CHAR(255) RESPUESTA=PyCallFunction('encoding_test','test_encoding', ALL.CHAR.STR) On the Python side I'm doing this def test_encoding(universe_str: str) -> str: for c in universe_str: print(f'{ord(c)}') return 'OK' This prints t

Other than using the LIST.INDEX command to see if an Index build is required, are there any other tools available to determine if an Index is in-sync with the data file? We are getting false negative results using LIST.INDEX.  Example:  SELECT CUSTOMER WITH NAME = "SMITH" 1 record selected Then if we try: SELECT CUSTOMER WITH NAME = "SMITH" NO.INDEX 3 records selected If we rebuild the INDEX then the Select will return 3 records SELECT CUSTOMER WITH NAME = "SMITH" 3 records selected  Also, what would cause the Index to become out-of-sync with the data file, and how can we prevent this from happening? ------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

I am currently unable to connect to u admin tool and receive the message below My U2.DATA.CLIENT applications written in visual Studio vb.net work fine The data base is 8.2 and is running on  my local machine ------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

I am using a windows based universe system.  I want to be able to do a listu type of command to see if a certain program is already running so that I can parse it in a basic program.  I saw the LISTUSER command, but that only shows the account path and not the program that is running.  I also saw the port.status command, but that is not installed on this system.  Can you please advise on how to do this?------------------------------Troy DittbernerPresidentNorthstar Data Services IncBrooklyn Park VA US------------------------------

Can someone tell me the proper syntax for SQL statement to Universe. I have a large file that I need to fetch 10000 rows at a time from Universe that will update a remote AZURE DB daily. I don't have control over the AZURE site as EDA seems like a much better solution to keep the remote data current.I have tried:SELECT TOP 10000 * FROM FILE;SELECT * FROM FILE LIMIT 10000;SELECT * FROM FILE FETCH FIRST 10000;SELECT * FROM FILE WHERE ROWNUM < 10000;Thanks JR Moore------------------------------JR MooreIT Special ProjectsRocket Forum Shared AccountHillsboro US------------------------------

i am currently unable to use uniAdmin to change default telnet login account What file can i edit to do this manually.. ------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

The dual terminal debugging feature seems to have stopped working correctly. I am on Windows 11 running Unidata 8.2.3. I used to use this feature heavily when debugging character base screens. Without duel terminal, that task is very difficult. When a debug is encountered, the cmd line program first shows "!" as it should but entry of any valid debug command returns: ***Illegal debugger command. Try 'H' for HELP------------------------------Kevin HondMr.Self RegisteredKingsport TN US------------------------------

We recently got an email from our security team regarding an ODBC vulnerability notice sent out from Microsoft. We are not currently using ODBC directly with UniVerse but it's probably still in use by our guys doing SQL. Just curious if anyone else has had to deal with this and if there are any results that may help others in the group. The two vulnerabilities are listed below: VUL0014881 - TEN-175440, Security Updates for Microsoft SQL Server OLE DB Driver (April 2023) VUL0014958 - TEN-175440, Security Updates for Microsoft SQL Server ODBC Driver (April 2023) Thanks!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

MultiValue Experiences version 1.9.0.1516 has been released on January 25 2024 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.

I have a client that runs Universe processes from cron. They do it by running a shell script that changes to the desired Universe folder and then execute "uv SOME.COMMAND".  Universe starts up and runs that command. The problem is, it first runs the LOGIN proc so if there's a menu, it displays that and only runs the command when they exit. They've gotten around that by checking to see if the user is running as root (which is how their cron jobs run) and going directly to TCL if that's the case. That works but has some issues. Is there any way to start Universe in an account but tell it to not run the account logon procs? Alternatively, is there any way from a basic program to tell if Universe was started with a command line argument? When you run uv with a command, does it push it onto the stack? How does it all work?

Greetings!Can someone point me to where on the Rocket site I can find high-level documentation regarding UniVerse EDA?  I have the docs that come with the UV 1.3.5 Documentation packet, but those are more setup and admin.  I'm looking for something I can use to help explain to those above me what it is and why we should use it - kind of like an executive summary/white paper.  I am hoping for more than the page that says "EDA is wonderful - contact us for more info", but less than the config/admin docs. I thought I had found it many moons ago, but am not having any luck today.  I am apparently not very good at searching for things on the Rocket site. Thanks!!Brian

Hey all,First time posting so I hope I'm in the correct area. Please correct me if I'm wrong.With the recent dropping of OpenSSL 1.1.1 support, I'm wondering if there has been communications from Rocket Software to support OpenSSL 3 for UniData 8.2.4. This is going to be a huge pain-point for our organization and are trying to prevent issues stemming from this if at all possible.From reading about OpenSSL 1.1 vs OpenSSL 3, there is a possibility of applications that use 1.1 to work with 3.0, but there's no guarantee. Backwards compatibility is limited. Another question because I'm curious: has anyone implemented openssl 3 for UniData 8.2.4 and, if so, were there any issues?Thanks,Brandon------------------------------Brandon BunchERP Solutions Specialist IIRocket Forum Shared Account------------------------------

Looking for a way to locate the proper attribute in an output record where the appropriate data could end up on different attributes depending on conte Example,  I 1st need to differentiate the type of record, which can be done with something like :    IF INDEX(@ID,"WoJournal",1) THEN <acttion1> else if INDEX(@ID,"PoJournal",1) THEN <action2> ELSE <action3> 2nd, each action will need to find the proper attribute where the "STATUS" is logged. Then it will need to extract the STATUS itself from the line which can use FIELD statements. Looking for the best way to find the attribute # (2nd step) ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

I am trying to get into the debugger in a program by typing the break key using <ctrl-c>, but all it does is print ^C.  I did BREAK ON before running the program. Is there a different key that needs to be used or how do I break to get into the debugger?

Troy,What terminal emulator are you using? Many of them intercept the CTRL-C key sequence thinking you want to use it for cut and paste. If it looks like all the settings in UV are correct, check the emulator settings.Brian

Does anyone have a guide or tips for setting up ODBC on Red Hat for use with the CONNECT command? UV 12.1, Red Hat 7.9. Our goal is to write to SQL tables directly from Universe programs - is this the correct approach? ------------------------------Matthew WrightAnalystTomago Aluminium Co PTY Ltd.Tomago NSW AU------------------------------

Good morning, I have a system that uses the terminal type "VT220".  A couple of reports that I offer the option of either display or printer require 132 columns to display.  I use the ESC:"[?3h" command to do this expansion and it works fine.  At the end of the report when I attempt to reset the display to 80 columns by issiuing the ESC:"[?3l" command it does not work.  The screen stays in 132 column mode.  Does anybody know how to get the screen back to 80 columns?  The emulator is AccuTerm 8. Thanks, Dale

Hi all. I'm using the inspect module to extract information about our code. The code runs well in the Python console but when called from Universe Basic I'm getting a Python runtime error. The Python side is really simple. I've reduced my code to a minimal example that reproduces it: File: leer_documentacion_min.py This is the module that does the inspection import inspect import json import sys def parameter_as_string(name, p): def_value = f' = {p.default}' if (not type(p.default) == type(inspect._empty)) else '' typ_annot = f':{p.annotation.__name__}' if (p.annotation.__name__ != '_empty') else '' return f'{name}{typ_annot}{def_value}' def leer_documentacion_y_funciones(script): try: if script in sys.modules: sys.modules.pop(script) modulo = __import__(script) # rest of the code documentacion = modulo.__doc__ if modulo.__doc__ else 'Sin documentacion.' funciones = inspect.getmembers(modulo, inspect.isfunction)

All, I was wondering... I have worked at many large UniVerse/UniData customers in my career. Some companies do a great job of certain facets of IT. I was thinking about contacting them to see if they would be open the a site visit. I realized that there could be proprietary secrets exposed during the site visit. After all I would not want to show someone around without some assurances that what they saw would be in essence 'What happens in Vegas Stays in Vegas'. Do you think there would be a way to display the best attributes of your IT shop without giving away the goods? What are the best practices that we can share with one another? ------------------------------Jon KristoffersonPick ProgrammerSnap-on Credit LLCLibertyville IL US------------------------------

Good morning.  I am a contractor and have been working in multi-value systems since February of 1980.  I have two customers in the Nashville area for whom I have worked for over twenty years.  Both of them look at me and recognize that I'm an old man and their only support for their systems.  Each is a local government department.  For one I have provided reservation/registration and for the other a highway department management system.  My highway department, to cover their future, is considering a vastly inferior system from the University of Tennessee.  I would like to find someone to back me up in providing maintenance and additional development for their UniVerse on Centos 8 system.  All the code is in basic with some AccuTerm getting integrated and all code is resident on both customers servers.  The highway department includes equipment scheduled maintenance, road job and requests management and costing, purchasing and inventory control.  If there is anyone out there who would c

We utilize &COMO& for logging process activities that are run in brackground.  This works great for our purpposes, and we can turn this feature Off/On by process in a control file record. However, on our Development machine, a number of records appear whose origin we cannot determine.  Here is an example (SLICE is possibly one of our U2 account names OR could be a test user's login): >CT &COMO&     SCHEDULER_SLICE_308680740001 COMO SCHEDULER_SLICE_30868074 established 11:07:20 05 DEC 2023 Notes: Our production system does not seem to get any of these. We run Universe 11.3.1 Pick format on AIX 7.2 Does anyone have an idea what is generating these?  Nelson

We're kicking off the Rocket® MVIS 2.1 Beta later this month, giving you an opportunity to get a sneak peek at the latest and most advanced version of MVIS yet, loaded with groundbreaking features including Open Telemetry. Sign up now! Here are a few features you can play with and help us test: ·         Support for Open API 3.0: Explore the power of Open API 3.0 with enhanced support in MVIS 2.1. This release ensures compatibility with the latest industry standards, opening doors to new possibilities for your APIs. ·         Top-Down and Bottom-Up API Design Patterns: MVIS 2.1 introduces both top-down and bottom-up API design patterns. Developers can now create MVIS APIs either starting from a predefined Open API spec or generate Open API-compliant APIs from MV data and business logic, offering flexibility in your development approach. ·         Expanded Vanity URL Capabilities: Building on the success of MVIS 1.3, MVIS 2.1 takes vanity URL capabilities to the next level. Enjoy full s

Is there a way to have the various anti virus applications out there not flag Universe as a virus? Is there a registration process with the av vendors that Rocket can go through? ------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

When calling python a second time from the same session I get the dreaded MPD_MINALLOC error. I know there have been a few threads on this same error and the fix is REINIT.PYTHON set to OFF. We are on Universe 11.3.1 (on RH7) and our system does not appear to have that verb available is there a way to install that verb? I did attempt to add that to our VOC but it does not find it. The REINIT.PYTHON is present on my personal version loaded on my windows machine.      REINIT.PYTHON0001 V0002 REINIT.PYTHON0003 I0004 G0005 Thanks JR Moore------------------------------JR MooreIT Special ProjectsNational Auto Parts Warehouse LLCHillsboro OR US------------------------------