Rocket MultiValue

We found an issue in OpenDB in which an attempt to manipulate an SQL table that only has a primary key and no additional columns fails. A known-issues post will be made in the Rocket Community OpenDB Downloads section as follows:Known Issues:OpenDB cannot be used against an SQL table that contains only a primary key and no other columns as this causes an error in the WHERE clause of the SELECT statement.This has only happened to one customer who worked around the issue by adding a dummy column to the table. I've never seen this before and seriously doubt I ever will again.One must ask one's self: "Why the heck would one have an SQL table with a primary key and no data?" If anyone has a good answer for that one, please post a reply herein.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

I asked Rocket Software a few years ago whether there would be a library call like UDO for JSON which you can use in Unidata/Universe.Is there such a subroutine, function, or library call in D3?If not, are you using string manipulation to remove, add, and create JSON data arrays and objects?------------------------------Doug AverchOwnerU2 Logicwww.u2logic.com------------------------------

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

Our company uses 2 UniData accounts, one for production (/ud/PRODUCTION) and the other for testing new features (/ud/TEST). Is there a way to configure UniData's python implementation so that it gives preference to python packages based on what account a user is in? For example, I might have a production version of a python file (usefultool.py) with a callable function in it called 'dothistask'.   def dothistask(): print('I did it') return 'useful value' and in a uniBasic program, I could access this function by running VALUE = PyCallFunction('usefultool','dothistask') This package is located in /ud/PRODUCTION/PP. But I want to add a feature or function to this package, but don't want to affect production implementation. So I add this python file to /ud/TEST/PP. Unfortunately, there doesn't seem to be a way to make each account prefer one directory over another when importing a function, so operations in the TEST account continue to favor the package version present in the produ

Is there a best practice way to version python packages between production and testing UniData accounts on the same server? The .pth files load in the same order regardless of which account a user is in (which makes sense), and relative paths + environmental variables don't seem to be supported in .pth. Was hoping to be able to make and test changes to a package in a directory under the testing account and move to the production account only when ready, possibly updating a production package. Separate servers, while desirable, in not possible right now.------------------------------Charles Sasaki-SkoppIT Coordinator/DeveloperVSIAlbany OR US------------------------------

Hi all,How does one prevent users from resizing screens in SB/XA by dragging the bottom right hand corner of a screen?Screen sizes can also get messed up if screen resolution is really low.Note: I'm not talking about zooming.Also if a user does resize a screen... Is there a way to have it reset back to the original dimensions as was defined when the screen was created in the screen designer?Some dialogs such as intuitive search dialogs reset by double clicking the bottom R/H corner but this doesn't seem to work for my screens.Thanks in AdvanceAaron

I have encountered a weird behaviour of UniVerse 11.3.3 on RHEL .If I run a globally cataloged command and supply command line parameters the command processor does not attempt to run the program at all.As an example I have referenced an existing subroutine in the global catalog, just to prove that the code does get run without parameters.>*SYSFILE_CRTCannot RUN a subroutine that has arguments.>*SYSFILE_CRT HELLO WORLD>I have tested this on UniVerse 11.2.5 on RHEL 7 and had the same result.Is there a known issue with global catalog code not running if command line parameters are supplied?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

Hi allI'm doing a simple test using uopy to write some data to the 'UP' file. with uopy.connect(host=...', user='...', password='...', account='...', encoding='cp1252', service=uopy.UV_SERVICE, port=31438) as session: codigo_subrutina = [ "SUBROUTINE PRUEBA.ENV(XINPUT,XOUTPUT)", "*", "* Programa Universe de prueba. Test tildes: á, é, í, ó, ú.", "*", " XOUTPUT=""Salida del programa""", "RETURN"] nombre_subrutina = 'PRUEBA.ENV' with uopy.File('UP') as up_file: up_file.write('PRUEBA.ENV', DynArray(codigo_subrutina)) print(up_file.status)​ I'm getting the value -2 in up_file.status.What does this mean? Is there some documentation about this status values?

Does anyone know a linux or Unidata command to see what account each user is currently logged into?Thanks!

We are in the middle of a project to convert our old RedBack Objects over to SOAP Web Services.  I was hoping someone might be able to provide some suggestions to get around some really user-unfriendly aspects of the tool. When launching the Explorer, is there any way to have it default the Navigator to the WSDL?  That is the only thing we use, but it defaults to the UDDI.  Once we switch to the WSDL, it requires it to be selected twice to get the WSDL URL prompt. Once you get to the WSDL URL prompt, is there anyway to get it to default to the End Point?  Every time, we have to copy/paste it from the properties tab.  Since the tool knows what it is, one would think this would have been a no-brainer default. Once an Operation has been chosen to test, we have not found a way to easily switch to another operation (maybe missing something).  The only way we have done it is to close the Explorer and endure #1 and #2 above all over again. We are in no position to switch to any newer "tool"

I have a need to track some statistics with Web Services operations.  The U2 programs that run under the covers all call a subroutine that picks up some control file flags, so it seems like that would be the place to log the stats (one program change covers all 22 operations)I do not want to impact the responsiveness of the web services any more than necessary.  I see the following choices: hard code the stats update logic in the shared control flag pickup subroutine call a new external subroutine that actually does the stats update find a way to call the external subroutine and keep going while the external subroutine continues until it has finished updating the appropriate stats (kind of call and release).  Unfortunately, I do not see such a command in U2 Basic (not CALL, EXECUTE, PERFORM or CHAIN). If anyone can offer some real world advice or suggestions, I would appreciate it.Nelson

Is there a way to get Unidata to respect a change to VFIELDSIZE without arestart? I have the setting being exported in a profile.d script and it'sset on interactive logins, but Unidata doesn't seem to want to respect thechange.

Don't miss the last roadmap presentation of 2021. Learn what's new in the most recent product versions and what's next in 2022. As always, we welcome you to share your reactions and feedback in the forum. We're running two live sessions so there's a opportunity for all to attend no matter where you live.Sign up here. ------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY United States------------------------------

Don't miss the last roadmap presentation of 2021. Learn what's new in the most recent product versions and what's next in 2022. As always, we welcome you to share your reactions and feedback in the forum. We're running two live sessions so there's a opportunity for all to attend no matter where you live.Sign up here. ------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY United States------------------------------

I am using UV 11.3.3 on RHEL7 for this investigation.I am trying to resolve the logged in user's group numbers into group names.The BASIC SYSTEM() function has a number of options to get a user's group details: SYSTEM(29) returns the current "gid" - as a group number SYSTEM(30) returns the effective "gid" - as a group number SYSTEM(1017) returns  the user's supplemental groups - as a dynamic array of group names SYSTEM(1403) returns all the local system groups - as a dynamic array of group names Having access to the user' supplemental groups makes it possible to establish security controls for parts of the application.Basing such controls on the group id rather than the name would make the security setup un-portable as there is always the possibility that the group ids will change on different systems.I have not found a system function that returns the group id and group name together.I can execute SH -c "id -gn" in order to get the user's primary group name.I can execute SH -c "id"

is it safe to run "uvlictool clean_lic -a" on a unix system while users are logged on? Thanks,------------------------------mark eastwooddeveloperAFS Technologies IncPhoenix AZ United States------------------------------

I have had a problem for years that when my UniVerse Basic program was attempting to create a security context record, it would create the 1st one just fine and then hang up trying to crate another one.  With the help of Rocket's Brian Kupzyk, we finally found the problem.There is a file in the account named ".bscrfile" that the saveSecurityContext writes to.  Protocol logging showed it was unable to open it, so the save left a lingering RD lock behind (even when breaking out of the program).After increasing the Unix permissions to 660 and setting user & group appropriately, the problem disappeared!Brian has generated a low priority engineering ticket UNV-31674 so Rocket may eventually fix this.In the meantime, this is the workaround for those of you who use SC's who may encounter this problem.Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH United States------------------------------

Very simple... UV Basic calls a Python function with a simple print() statement.  However the python print() statement doesn't print.  Much obliged in advance for any insight.

i just started working at a d3 shop after working with U2 for years. I am very surprised that D3 does not have the U2 AE editor. That AE editor makes it a breeze to view and modify VM and SVM data. I do not understand why it not available. It is just a special text editor.​------------------------------William MoffaSoftware DeveloperSelf RegisteredOld Bridge NJ United States------------------------------

Modernization. You probably see this word all the time. I'm curious, what does it mean to you? Specifically, what does modernization mean for your business-critical application that is built on a MultiValue platform. Your organization has invested in your business-critical MultiValue-based applications over the course of years and maybe decades. How do you ensure those applications can adapt and grow alongside your organization for continued return on investment for years to come? If you're focused on increasing productivity, are you looking at development tools and modern programming languages that are easy to use, efficient, and address the skills gap? If you're focused on simplifying integration, are you interested in lightweight, zero-install client applications with Open APIs? Is speed to market at the top of your list, including implementing continuous integration, continuous delivery (CI/CD), cloud (on-premises or hybrid cloud deployment and containerization)? If you're not focu

Hi UvFriends,Do you known if a upgrade of u2client.net (u2netdk) upgrade to support .Net Core is available ?At least the Core Uniobject ?have a good day.

Hi, I have installed MV Basic for Visual Studio Code. It's really cool. I could open a basic programs folder, but could not connect to the database, so I can't compile, or have the additional features I saw it provides when connected.  I have followed the documentation of this Forum, downloaded the JDK 11 from the indicated link, placed its path in the MV Basic Extension configuration, and created the following .rmv/db.mvbasic.json file:{"db": {"host": "192.168.2.100","userName": "root","password": "123456","account": "ALEDB","dataSource": "UNIVERSE","port": 31438},"includes": [{"includeFile": "BP","account": "ALEDB", "fileName": "BP"}]}  First of all, whenever I open a Universe Basic, the following message appears in VS Code:Java 11 or Open JDK runtime environment is abnormal. Please check your Java environment and settings  Second, when doing F1 -> Connect to MV Server, another messages tells me "Connect to U2 server failed"  Any ideas?  Regards,------------------------------Enriq

Have heard these sad stories of fool hardy conversions from MV to solutions selected as a result of recommendations by consultants, accountants and teh like.We have developed and implemented systems in MV over 40 years.The frame works that we built 30 years ago still stand robustly .The key words  used when confronted are:1) They say Legacy system: we counter by saying you mean a 9am to -5pm  system?2) The say MultiValue ???   We say: you mean you want to see the data like you see in a pivot table in Excel right ? or do you want an entity relationship diagram?3) They say difficult to maintain and modernize the system: We say we are technology independent .. tell us what you want and what frame work you want us to use to develop in? we will use  the framework that you recommend. 1) dont forget when we first used MV to develop systems the frame works were mainly  I/O (input output) . These systems were used by people who came in at 9 am and worked on thier green screens to input data fro

Hello all.  With the new error tooltips in 1.2.0, many of the programs I'm viewing show numerous error for Undefined Functions.  Is there a way to turn off these specific errors, or is the intention for us to setup our workspaces to have access to every function/subroutine needed?Thank you

Well,  Interesting announcement this morning!!I have been hesitant to mention MVConnect as a great solution to modernize D3 since the product wasn't owned by the resource we are communicating on.  As of today I can!!!  While rocket has the MVToolkit that they are working on I prefer the MVConnect product as a solution and have built our web integration upon this product.The product is light weight and allows full control of the disbursement of data via pick basic and the business logic you currently have in place.MVConnect ROCKS!!!!I encourage all to take a look at it as a solution to your modernization needs.------------------------------Craig CurtisSystem ProgrammerSevier Valley School DistrictRichfield UT United States------------------------------