Rocket MultiValue

If you are considering upgrading to Rocket® UniVerse 11.4.1 and use either Rocket SB/XA (all releases) or Rocket U2 Web DE 5.3.0 or below, you need to plan your upgrade to avoid disruption to your System Builder and Web DE applications. Rocket UniVerse 11.4.1 includes OpenSSL 3.0. With the upgrade of OpenSSL, we also disabled unsafe encryption algorithms including:•    Hashing Algorithms / Message Digests: MD2, MD4, MDC2, WHIRLPOOL, RIPEMD160•    Symmetric Ciphers: Blowfish, CAST, DES (DES_ECB, DES_CBC, DES_OFB, DES_CFB, DES_CFB1, DES_CFB8 and DESX_CBC), IDEA, RC2, RC4, SEED•    Key Derivation Function (KDF): PBKDF1 Both SB/XA and U2 Web DE 5.3.0 (and earlier) rely on disabled encryption algorithms and won’t work unless you reenable them. For SB/XA your options are:•    Enable legacy algorithms (instructions below)•    Postpone your UniVerse upgrade. We are working on a Hotfix for SB/XA 6.5.7 to upgrade the encryption algorithm used by SB/XA. We plan to release the hotfix before the en

I sometimes see an error message when trying to re-license after an update (which I've been doing a lot recently to get customers up to 3003). "This web address is for US and Canadian customers of RBC.  Please click OK and click the indicated URL to continue." This is from https://rbc.rocketsoftware.com/authprod.asp.  I usually wait a day or two (but not ten!) and go through the process again and it usually seems to work.  I could be entering the details a different way the 2nd time?  The customers work with the VAR to get the license details, so I'm one step removed from requesting and managing the serial numbers, they just call me when they need help. Anyone else seen this, or have advice on what I'm doing wrong? ------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

I'm posting this to alert anyone who's got large multivalued attributes they may want to sum in AQL. A friend of mine logged a case recently where a correlative using the S() function would hang when the file has any items where the attribute in question has more than 32,768 values. Engineering confirmed that this is an AQL limitation because it's using a 16-bit signed variable to track the value count. This variable is used in many places in AQL, and it would be a huge task to rearchitect. In the course of debugging this, Engineering came up with a workaround by using CALL in the correlative. This not only removed the 32,768-value limit, but it is also MUCH faster. Example of the correlative that hangs (using multivalued attribute 9 in the example): 008 A;S(9) Example of the correlative that works (again using multivalued attribute 9 in the example): 008 call bp sumbal Might be a good idea to fully path the subroutine being called. Example of a subroutine in an account called "orders"

I saw some teasers for 8.2.5 a few months back - is there an online "what's coming soon" for Unidata anywhere?------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

Hello I am hoping someone can help with an AccutermIO query. We are following the instructions..... AccuTerm Release Information V8 and we are trying to create a profile. 2 Profiles already exist, thet were created prior to Rocket aquiring Zumasys. When we create a profile we are not getting a check box display for the Role (admin/dev).  We create the profile anyway, but when we launch Accuterm we get the error No profiles have been created. Please login to Portal and create one.  Can anyone please advise on what we are doing wrong. As an aside, the portal we are using is the Zumasys portal, https://zs-portal.rocketsoftware.com/accuterm, as this is where we were redirected.------------------------------Richard OldsSnr DeveloperCalidore Computer Systems LtdGATESHEAD GB------------------------------

Hello, I have a script to launch the  ACCUTERM GUI application from a shortcut in desktop but when the user closes the GUI application the ACCUTERM session is still active letting the user to play around, so the user has to close again the ACCUTERM session.  We need a script to launch the GUI application and when closing it also close ACCUTERM session so the user gets back to desktop screen.   I tried  the  following script but it is not working: .Output "RUN GUIBP GUIAPPLICATION" & ChrW$(13).WaitFor 0, 8, "o:" .Output "QUIT" & ChrW$(13) I will appreciate any advice. Thanks.

I've been asked this before, but did not have an answer!  On Unidata -- in a dictionary -- to do a multivalue OCONV, the command is SUBR("-OCONVS",X,Y) The question I got asked:   "Why is there a "-" in front of that code?" And I was not sure!  Is that because it's a system function?  It's not actually documented as to WHY -- just that it IS. I just looked over the Using UnIData 8.2.4 doc to make sure it was not something documented. Anyone know for sure what the "-" infers or confers beyond my guess that is means 'this is a built in system command'?------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

Hi all, we have many web aplications invoqued from some users via unirpc, and sometimes we are out of available licences for interactive users, are there a way in universe to limit the number of connections that each user can start? 

This is the second MVX: Performance release focused on improving replication as part of a MultiValue HA/DR strategy.  This release includes a new replication dashboard allowing users to quickly and easily perform replication monitoring tasks to assess, in real time, the health of replication activities. The replication dashboard includes details such as a statistical summary of multiple distributions and identifies the stalled LSN causing a subscription group to stop processing. A stalled LSN has been the number one replication-related support case our customers have submitted. This version of MVX: Performance provides resolution steps without users having to reinitialize servers. The dashboard also displays trend information such as pacing time behind and time to catch up.  In addition, v1.8 features three new replication events: ·        Replication disabled event: generated for one event per distribution if any groups are disabled. ·        Replication down event: generated if repl

MultiValue Experiences version 1.8.0.1347 has been released on October 19 2023 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.

Nevermind, figured it out. Apparently this forum is an excellent rubber duck. If some kind soul at Rocket would add SQL.WLONGVARCHAR and SQL.WVARCHAR to ODBC.H that would be very nice.

In the world where OpenDB can write D3 data to (say) an Oracle Table, have any of you had the experience to (for whatever reason) write from Oracle to D3? In other words – (say using the ODBC) - I can use SQL statements to INSERT/UPDATE and DELETE a row; this "instruction" is driven from the Oracle side in order to facilitate a D3 file (record) to be modified (WRITTEN TO / UPDATED / DELETED). How do you deal with the aspect of Multivalued fields – the D3 SQL documentation is a little flaky IMO and there are no real examples of what I wish to achieve and that is to INSERT/UPDATE a value within a MULTIVALUE (defined) attribute. The “safe” alternative is to write to a “normalised” D3 table and then have a function in D3 to sort things out! I'd like to know how you may have solved this in a more elegant manner. Regards Stefano

Hello, I am new to Accuterm and the project I am working on requires a date field. Is there any calendar picker component that could be used? The GUI designer does not provide a component like this. I will appreciate any help. Thanks.

I cannot see how to retrieve information returned from a script into my basic program. For example:SCRIPT  = 'width = Field(WindowPos(0),",",3)'CALL WIN.COMSUB(SCRIPT)how do I get the returned information back into my Unidata basic program?

We have hundreds of desktops running wIntegrate version 6.4.4.  After migrating to RHEL we want to find an easy method to enable SSO for all our desktops with wIntegrate.   We would like to run an automated script (using powershell or something) to update all our desktops so we don’t have to update each desktop individually, but the manual states that you cannot edit the session .wic files with a text editor because the files are in a binary format… that you need to use the wIntegrate Editor to edit the .wic files.  This doesn’t sound like something that can be easily automated. We have experimented with using a text editor (Notepad++) to update a .wic file before, and wIntegrate seems to properly recognize the changed setting... so it seems feasible that an automated powershell script could find and update all .wic files with a new setting.  Has anybody else had success updating settings in a wIntegrate .wic session file without using the wIntegrate editor to comp

I am on Universe. I get the following message when I try to delete a file.  "unable to unlink the operationg ssytem file" then it lists the file name. Then it follows with "DELETE failure". What does this mean and what can be done about it?------------------------------Konson GeeProgrammerLiahona Development SolutionsBonney Lake, WA, United States------------------------------

it comes with openssl 1.1.1n  it is possible to update the openssl version by: replace the version in udt version sym link to another version  update the path so it find the redhat version first some other way/suggestion that I am not aware of and will this break anything in udt? thanks dougc ------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Introduction I've installed the U2.EntityFrameworkCore NuGet package and successfully set up basic queries using my DbContext. Now I've hit a roadblock trying to call Universe subroutines Problem Description With basic CRUD operations functioning as expected using my DbContext, my next challenge is to call Universe subroutines. I can't seem to find clear documentation on how to achieve this when using the U2.EntityFrameworkCore package What You've Tried I've gone through the U2 Toolkit documentation, but it doesn't cover EF Core 6 specific implementations. I've also attempted to manually execute the subroutines using various EF Core methods, without any success. Questions Has anyone successfully called Universe subroutines using the U2.EntityFrameworkCore package with EF Core 6? What is the recommended approach for calling Universe subroutines in this setup? Are there any code samples or tutorials available that cover this specific scenario?

Can anyone explain when the ODBC driver returns a DUP_COUNTERS result?Google very "unhelpful" here :(

Introduction I've also installed the U2.EntityFrameworkCore NuGet package and successfully set up basic queries using my DbContext. Now I've hit a roadblock trying to call Universe subroutines. Problem Description With basic CRUD operations functioning as expected using my DbContext, my next challenge is to call Universe subroutines. I can't seem to find clear documentation on how to achieve this when using the U2.EntityFrameworkCore package. What You've Tried I've gone through the U2 Toolkit documentation, but it doesn't cover EF Core 6 specific implementations. I've also attempted to manually execute the subroutines using various EF Core methods, without any success. Questions Has anyone successfully called Universe subroutines using the U2.EntityFrameworkCore package with EF Core 6? What is the recommended approach for calling Universe subroutines in this setup? Are there any code samples or tutorials available that cover this specific scenario? #U2Toolkitfor.Net #EFCore6 #Un

I believe I was told that when upgrading UDT from a previous version maybe 8.2.x to 8.2.4 its possible to update the license programmatically? currently we have to use confprod A message displays: You have 10 days to call U2 before UniData stops working.  5.      Type Ctrl+F to generate the configuration code.  6.      Copy the generated configuration code to the clipboard; it will be used to obtain the authorization from the vendor in the next section.  Note:   Consider saving a copy of the configuration code in a text file such as Notepad.    Obtain an Authorization Code  UniData is owned by Rocket Software. No log in is required to obtain a product authorization code.  Use this link to authorize UniData: https://u2tc.rocketsoftware.com/authprod.asp  2.      Read and follow the instructions on the web page.  3.      On the Rocket Web page, change the Select Product dropdown box to UniData and click Continue.  4.      Enter your eight-digit serial number, which is the license numbe

Good day, I'm supporting a IBM Power AIX environment, which I have been working with for about a year. Along with sorting out the general maintenance of the systems and moving to AIX 7.2 there is a large UniVerse environment on the hardware I support. So I've done a little reading, as I didn't build these environments, about recommend tuning. I couldn't find anything specific, so along with what I've found, I wanted to see if there was anything else I could do or look into. We have a number of test environments, and servers that I can build to test these things on.I have found some mention of tuning JFS, first was check the type of filesystem mount, if CIO enabled disable it. Then set 'ioo -p -o j2_dynamicBufferPreallocation=64'. I've also seen mention that j2_nPagesPerWriteBehindCluster should be changed from the default 32 to zero I have some ideas of things I might like to try and see if they made a difference, setting the  "/usr/sbin/syncd 60 > /dev/null 2>&1 &" defa

Have a quick question. In JED, what is the hot key to enter a TM (char 251) into a record? The VM and SVM are clearly documented. In Universe in ED i would just go into Up Arrow Mode  and change it there, but does not seem Up Arrow Mode is supported in ED on Jbase. Editing this in HEX does not seem supportable and I'd rather not have to create a user interface for this for a super user. I do see it's supported through RAISE() and LOWER(), so it should be there. Also see that @TM is supported. ------------------------------Greg MotterRocket Forum Shared Account------------------------------

hi everyone,   I created my own application. And it is a desktop application and it works with Unidata and Unibasics. I used Accuterm as an editor for my application. The output of my application screen shows as an old theme when I use Accuterm editor. The button, text, and color make my application old. I try to make my application screen look better. I want to make my application look good with a modern UI, I used Accuterm like Microsoft Visual Basics, Can anyone help me, please Azar

On a Windows system (Windows version is 10.0.20348.1970) running UV 11.2.5 in PICK format, we have a BASIC program that executes a DIR command. EXECUTE "DOS /c DIR" CAPTURING OUTPUT  The time column shows the timestamps in 24 hour format. However from a Windows DOS Command window, if we type DIR the times are in 12 hour format.  My question is how can we get the time format to be in 12 hour format when running the  program? What is UV looking at to determine the time format?  BTW we get same results when we use DOS command at TCL to get to the DOS environment and then type DIR.  Screen shot attached with Windows Command prompt window on left and Accuterm on right. Thanks in advance.