Rocket® U2 | UniVerse & UniData®

I have some questions / confusion concerning shells. I know that at different companies I have worked they have allowed different shells - korn, bash, bourne, etc.  Is there a standard for invoking each of these shells or is that defined by the admin within each system? !sh, !ksh, !bsh.  Is there any documentation on how to set these up? A way to know which shells are being invoked by the commands?  And a way to update paramaters within each? Thank you for your time, Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Have you thought about changing the CENTURY.PIVOT? We've had some customers attempting to report date bugs as we approach 2030 which are in fact not a bug at all but just a misunderstanding of the CENTURY.PIVOT setting. The century pivot point is the year used to determine the century when an ICONV is done on an external date that only provides a 2-digit year. I have attached a results spreadsheet to this post, so that you can review the different results of setting CENTURY.PIVOT against a 2-digit year ICONV and then seeing the result using an OCONV with a 4-digit year. You can check the century pivot point with the CENTURY.PIVOT command at ECL.>CENTURY.PIVOTCentury pivot date is 1930 You can change the century pivot point for your current session with the CENTURY.PIVOT command, or change it for everyone by changing it in system wide configuration file. (udtconfig for UniData and uvconfig for UniVerse ) From the UniData Help The CENTURY.PIVOT ECL command overrides the system-wide ce

Good Day Fellow Members! I have an interesting issue with the "LOGTO" SB+ command.   I am trying to allow a specific Security Group to have access to our TRN.DATA account.  (Our "TRN.DATA" is a our "sandbox" account to allow our power user(s) to test new processes and/or experimenting with setting up our business needs.) Currently, when I ask the user to perform a "/LOGTO TRN.DATA" , they get "TRN.DATA ACCESS DENIED".   (I have added an attachment on what the users are seeing.)    I have tried to add the account to the Security Group through the SB+ Security Group Maintenance, but the updated data is not being saved to the Security Group record. I did ask our Unix administrator to check the permissions and our admin did make adjustment to all user to access the account.  However, this did not resolve the issue. So, my question to the group is what I am missing?  What do I need to look at or investigate? Any suggestions and feedback will be welcomed. Thank you for your time and consider

Greetings!I'm not sure if I can explain this one very well, but I am going to try. We are running UniVerse 11.3.5 on AIX 7.2.  We noticed some oddities when writing to a Type 19 file.At the AIX level, the ownership of the Type 19 file (parent directory) is root, and the group ownership is a group called installs.  UV runs as root. User xyz (group staff) runs a process that writes to the Type 19 file.  If I monitor the contents of the folder at the Unix level with an "ls -l" command, and my timing is perfect, I will see that the UV record (Unix file) first gets created as a 0-byte file with xyz as the owner and staff as the group.  UV then finishes writing the file and at that time the owner is now root with a group of installs.This all happens in milliseconds, so trying to capture it 'at will' is nearly impossible.  I just keep running ls command repeatedly until I see it. I've never noticed this before, but I've never looked before either.  I'm looking now because we have another pro

Hello all - I'm sure this has been asked before but I couldn't find exactly what I was looking for... We are moving our Unidata 8.2 from Unix to Linux. I have been through such a conversion before some 15 years ago but thought others might have more recent recollection and encountered other issues. Is there a list of specific potential pitfalls to check?  Obviously the syntax of Unix commands changes to linux. Spoolers, FTP, emails, etc but what about any Unidata changes? I remember issues with the locate command... did others have that issue also? What other issues did you all find? Thank you in advance for your time, consideration, and assistance. Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

I have just loaded python3.13 and flask onto my rocky 9.5 system.  The system already has python3.9 as part of the rocky linux.  I have just installed idle3 wanting to use it to work with python3.13 and flask but find that it connects only to 3.9 where I do not have flask.  Does anyone know a way to either modify idle to connect to my 3.13 version or is there any way to get the "dnf install" to load it into my 3.13 directory structure?  I prefer to use idle instead of the plain 'ol text editor. Thanks, Dale

I keep getting the following error when migrating my UniData application to SB 6.5.7 In /usr/ud/SB.DEFN/DM/_SB.DISP at line 173 can not access unopened file. File variable not used in file operation In /usr/ud/SB.DEFN/DM/_SB.DISP at line 173 Fatal error: WRITE error How do I deal with it? The file is there with the correct permissions but I am not sure what it is referencing at line 173 so I cannot update the respective VOC pointer------------------------------John FigloreRocket Forum Shared Account------------------------------

Hi, I'm new on Unidata. Right now our company is using Manage 2000 with Unidata RDBMS 8.2 version. My question is, is it possible to open my unidata database to SQL Server Management Studio, how? If it's not possible can I create a view on SQL Server Management Studio containing all the data from my unidata database, how? I already created a view file and successfully compiled it but I can't still see it on the SQL Server Management Studio. I also created a link server on SQL Server Management Studio using the U2 ODBC.

We currently have a large application written with Universe BASIC and Menus.  is there a way to set a global timeout value for user input?  This is an audit requirement.  ------------------------------Sandy BarrySenior ProgrammerRocket Software Forum Member------------------------------

Good morning everyone, We have an issue with a TRANSACTION COMMIT failing with a STATUS = 3. The Unibasic subroutine containing the TRANSACTION START/COMMIT code is called from the outside as a web service. This failure is intermittent.  What can cause the STATUS code = 3 ? Thank you in advance. André Guindon

It's been a while since I had a need to do this. Anyway, I have a process that runs through a file to move data to another system.  I like using the spooler for this since it makes it easy to verify the data. The secondary print will deal with some corresponding multi-values that can be too large to flatten out in the main print job.  Since both are running from the same file it would be nice to be able to print both reports at the same time.  My alternative is to build a sequential file for the 2nd report and copy it to the spooler. Any help with this would be appreciated. ------------------------------Mark Vander VeenIT ManagerUniversity of Chicago PressChicago IL US------------------------------

I just bought a copy of OpenQM to test some of my applications.  My first program to test is a main menu.  In this MVBASIC program I draw a character outline around the border of the screen, the fill in the menu options.  The program then calls a suproutine called XPRMT.  I use the XPRMT subroutine for all keyboard input in all programs, it is the only INPUT statement in my systems.  One of the parameters that I pass to XPRMT is PSTR which is the prompt string which XPRMT prints at @(0,24), the bottom of the screen.  In UniVerse this routine works perfectly, but in OpenQM it was displaying the PSTR value over the bottom line of the border which is row 23.  My last line printed in the menu program was the log off selection at row 22.  After much code changing in XPRMT, I modified the menu program to display the menu selections first and the draw the border and that presented everything properly.  What I see is that even though the XPRMT instruction is "PRINT@(0,24):PSTR;", PSTR is being

Right now my RESTful calls come back as Error 500 unable to connect during a dbpause.  If I turn on the serverdebug I can see in the logfile the message: dbpause is set, try logging in later (or something like that).  I see the same message from telnet logins. Is there a way to capture this message for my Web pages using RESTful calls via an AJAX call?------------------------------David GreenComputer ProgrammerRocket Forum Shared Account------------------------------

Is there an easy way to delete a command from my Unidata command stack, or do I have to end the session and remove it from what was saved under my user profile?------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

Currently this is timing out at 60 minutes. Where is this timeout set? Can it be adjusted? Thanks!------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Greeting all! New to Universe so my apologies for the rookie question.  Is there any to determine when the last date/time a program was compiled and by whom?------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Hi everyone, We're currently evaluating Evoke by BlueFinity as a front-end solution for our MultiValue system and recently had a demo which looked quite promising. The plan is to move forward with it, but before we do, I wanted to check: Has anyone here had hands-on experience with Evoke or mv.NET in a production environment? Any feedback-positive or negative-regarding integration, performance, support, or limitations would be much appreciated. Thanks in advance! Thomas------------------------------Thomas LudwigSystem Builder DeveloperRocket Forum Shared Account------------------------------

Hi, Is anybody aware or know if System Builder 5.1 (pre SB+ I know it's ancient) was ported for a Linux platform (for Unidata)? Thanks.------------------------------Rashid HoosenDeveloperInvestec Bank LimitedSandton ZA------------------------------

What syntax do I need to prompt the user - who runs a program from the terminal - for input, but I don't want it to echo back to the terminal? ------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

Hi all Is there a way tu call pip via RUNPY? Usually I do server maintenance and intallations via shell, like this SH-5.1$ /u2/uv/python/bin/python3 -m pip install some_module SH-5.1$ /u2/uv/python/bin/python3 -m pip freeze Of course, it the server is running on windows things are different, so I was wondering if there is some way to interface with pip using the Universe command line, and not the operative system shell. ------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

Have you heard about the MV event Rocket is hosting at the Gaylord Rockies Resort & Convention Center in Denver from June 11-13, 2025? Whether you're a business leader or a technical expert, this is a perfect opportunity to explore new possibilities for your Rocket® MultiValue applications.   Why attend? Business and technical tracks: Gain the knowledge you need to focus on business strategy or the technical aspects of application modernization. Networking opportunities: Meet with peers and partners who share your goals and challenges. Hands-on labs and demos: Experience the latest innovations firsthand. Thought leadership panels: Hear from industry experts and learn how other customers are modernizing their Rocket Software applications.See the full agenda Register today------------------------------Mike RajkowskiMultiValue Product EvangelistRocket Internal - All BrandsUS------------------------------

example of code: REQID STIND OF 8 DIGIT REQUEST NUMBERS, IE . 12345678 GTC1=LITERAL FILEIN = /main/submain/submain/DESTINATION/REQID:".GTC1" THE FILE DOESNT EXIST TO START When i run this program as a standalone is works perfectly. When i run this program as a PHANTOM it takes both else clauses OPENSEQ FILEIN TO OUT.FILE ELSE CREATE OUT.FILE ELSE MSG = "CANNOT CREATE ":OUT.FILE CRT MSG STOP END END RUNNING ON REDHAT LINUX 8.10 UNIVERSE REL 11.4.1.6020 PERMISSIONS HAVE BEEN CHECKED USER:GROUP ARE CORRECT any help would be greatly appreciated

Hi all, i have a bit of an issue with U2 ODBC trying to connect to uniVerse DB. I installed (at the then time v530 of client tools (ODBC 64bit) onto a workstation and then i was able to connect to the DB and query. Since then i have installed ODBC tools onto another workstation/pc/server (both on premise and within Azure) and completed the same setups i did previously but on these they do not work. i keep getting the same error message (as shown at the bottom of this post) i cannot use the existing workstaiton/PC as that client is not the one i will be completing the connection from when in prod (as it is my workstation used for testing) and also cannot use as unirpc is locked down to specific IP (the new workstation/PC i want to use in Azure).  With this being said, if i try to install ODBC onto another workstation, same result, doesn't connect. i am using both the ODBC Tester from the ODBC tools and the Test Connection option from windows (ODBC Data Sources 64-Bit) after creat

From the udt.errlog, the output of a deadlock warning: I can understand most of this, but what does PICK REC mean in this context?

I've been working with a friend on setting up a website that uses the U2 RESTful server.  My friend's been doing most of the work. It's been in development but there's a lot of things working. We named the rest server "rest_test". That's not a name that works for production so I'd like to rename it. The problem is, if I right-click on the server in the U2 REST Servers panel the rename function is disabled. I've tried copying the folder to a different name, exporting and importing it. No combination of steps has worked. I also don't like the number of steps you have to go through to "deploy" a rest server.  Export the file to a zip, unzip it, go to the u2restdeploy folder run the batch file to start the deploy tool, define where you want the files to be deployed to...  This is not a good model if you've got multiple developers making local changes that need to be moved to the server. So here are my questions: How do you rename a rest server? Are there easier ways to go d