Rocket® U2 | UniVerse & UniData®

Hi Guys, I needed to dump the contents of a transaction file for our Auditors today and a simple retrieve report should have been the simple solution, as it only need sorting by date with no calcs, and all the dictionary's already setup, and probably not needed again..... However, because of the 32,767 (ROW) page length limit the .CSV hold file with 680,000 rows of data, had many extra "page breaks" to dispense with. I was reluctant to write a one off program, so sorted it in the VOC paragraph, that produced the report, so the Auditors are happy, but  it took me longer than in really should have because of the 32,767 SETPTR limit. So does anyone know why we have such an arbitrary number as the limit for SETPTR and does anyone know of a simple override aside writing a one off program  to poke it directly into &HOLD& rather than using a retrieve report?? Also another thought, the SETPTR command displays your current output settings so these values must be stored for your current

I have a need to provide a user input prompt that times out gracefully after a specific period.I am using !EDIT.INPUT and that captures the input well.What I am missing is a graceful method of setting a timeout for it.I have attempted to use the AUTOLOGOUT command.That does trigger a logoff (an ungraceful exit but an exit non the less).Does anyone know of a way to assign an input timeout period for !EDIT.INPUT - or even just INPUT @ - that allows code to register and react to the non-input of data in a graceful manner?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

The Rocket Software MultiValue team is inviting all Rocket® UniVerse customers to participate in our UniVerse 11.4.1 beta program.  This is your chance to test, influence and provide feedback on UniVerse 11.4.1. If you decide to participate, here are some new functionality highlights you'll find in UniVerse 11.4.1 and Rocket® MultiValue Performance Experience (MVX Performance) 1.7 for customers on active maintenance. We've enhanced HA/DR and fixed some bugs, making it easier to manage your replication environment while improving performance Improve performance by implementing the Replication Intelligent Queue Manager, which allows a subscribing system to recognize when there are multiple updates in the queue to the same file Easily test a new version of UniVerse on a subscribing system while still running an older version of UniVerse in production because UniVerse 11.4.1 allows a subscriber to receive logs from older protocol levels Recover from stalled subscriber groups using the

Looking for UniData expertise in deploying and optimizing storage performance in Azure.  I have not found any official Rocket technical documentation to support.------------------------------Ralpha LabartaCTOEngage PEOSt. Petersburg FL US------------------------------

I'm using universe 11.3.4 and want to pass in parameters in when running a python program using RUNPY is this possible?------------------------------Neil SherwoodAnalyst ProgrammerHSBC Global Services (UK) LimitedLondon GB------------------------------

One of our Linux Admins asked if there were any Rocket recommendations on RHEL TUNED  package.  I didn't see any references in the knowledgebase and figured others might have input.  Here's the URL he referenced:  https://computingforgeeks.com/optimize-linux-system-performance-with-tuned-adm/------------------------------Charles CarpenterUV DBATailored Shared Services LLCHouston TX US------------------------------

Hey group!Is it possible to compile a Dataworks UniBasic program from a AIX - Unix command line?   Thanks!  ------------------------------PeterGonzalezMOUS------------------------------

The new podcast Doing More with MultiValue is live! Check out episode 1: Filling the Skills Gap In every company, the people, processes, and solutions change over time. Often there's a difference between the skill sets of the current employees and the skills best suited for the task at hand. Join host Mike Rajkowski and his guests, Jason Huggins and Virgil Ashruf, as they discuss how Rocket Software's new eLearning can help our customers and partners fill the skills gap. Here's a link to Apple and a link to Spotify. Or search for it by name anywhere you get your podcasts! Our pilot season will consist of 8 episodes, with a new episode airing every 2 weeks. ------------------------------Mike RajkowskiMultiValue Product EvangelistRocket Internal - All BrandsDENVER CO US------------------------------

MultiValue Experiences version 1.6.0.1064 has been released on April 27 2023 for the below platforms/versions:AIX POWER       7.1,  7.2AlmaLinux       8 (Using Docker 10.10.22 or higher)CentOS       7,  8RedHat Enterprise Linux Intel       7,  8Rocky Linux       8 (Using Docker 10.10.22 or higher)Windows       Windows 10,  Windows 11 (For UV 11.3.5 only),  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.

One of my customers has a phantom named "SLEEPY" that runs continuously making nightly backups, processing transactions from a Fuelmaster pump system and producing some daily reports. Currently we start SLEEPY manually from the Centos 8 console as "root" after each startup; UniVerse 11.3.4. I would like to automate his start as part of the boot process. I think I understand the .rc command to start the UniVerse session but I'm uncertain about getting it started as "root", spawning the phantom and then logging out. I would appreciate any suggestions.Dale

i am looking for information about XMAPAppendRec beyond what is published in the BASIC Extensions Version 11.3.3 document. Specifically, I am seeking details on why the serialized output to XML omits elements when the corresponding field value in the data base is empty. I am also curious about the function appearing to only process attribute 7 of dict items instead of processing attribute 8 for correlatives and attribute 7 for conversions. If I could just "look at" the source code for the function all my questions would be answered.------------------------------Brian ArnoldprincipalRocket Forum Shared Account------------------------------

[Rocket U2][U2ODBC][2300701]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: S1000; U2 Database code: 20085; Msg: [U2][SQL Client][UNIVERSE]Program ".ITYPE.": pc = 6, "*PAID.AR.CALC012" is not in the CATALOG space. .".Back in November, I was able to get connected to this U2 database from SQL Server, PowerBI, and other tools using OLEDB and ODBC as outlined in this previous thread:Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData I'm using the latest U2 64-+Bit ODBC Driver Version 7.241.02.9004.The ODBC Connection tests successfully and works perfectly in applications that use ODBC, such View this on Rocketsoftware > After a several month hiatus, I am now trying to work with the U2 database again, and getting this error related to the "CATALOG space" when accessing certain tables that I successfully accessed back in November.I am on the same PC, with the

Where could I find / how could I capture the output of a phantom started by a phantom?We have the code: EXECUTE 'PHANTOM ':TASKNAME CAPTURING EXECMSGE executed by a phantom program.Display statements in the first phantom are output as normal to its &PH& file.'EXECMSGE' contains "Phantom process started -nnnnn"The secondary process does its job, but any display statements are not written to any &PH& fileRunning the secondary process from TCL shows the display outputs at the terminalRunning the secondary process as a first phantom send displays  to &PH&.Running Universe 11.1.4 on Linux.. I'm not in a position to be able to change how it runs (but still need to support it)Thank you in advance for any help :)

I do LIST filename NAME   .... and got back results -- it was pulling Attribute 4 of the file.  Which, was just odd.  Turns out filename does not have a DICT called NAMEVOC does not have a DICT called NAMESO ... where did the system FIND this dict to display attribute 4?Once I installed a DICT called NAME In either DICT filename. or  VOC, it worked as expected.But still -- where was it looking to 'find' something called "NAME" that was returning attribute 4??THANKS!------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

We had an unusual issue where it APPEARS Attb 2 of a DIR VOC type cannot exceed a certain length.LIST / SELECT both work as expected.However, AE using an Active SELECT list or just 'raw' would return "New Item" and anything Filed would issue a WRITE error (Status =1) with a 'check for triggers' message -- which cannot be true on UD DIR types.After a while of not figuring out the issue, we moved the folder to make Attb2 of the VOC shorter and viola - the issue resolved.Does anyone know the character count allowed in attribute 2 of a DIR VOC type?  And more weirdly, why is only AE was impacted?  We might have found the issue earlier if SELECT and LIST did not work either -- as it was, we were running down to see if there were some weird permissions issues - and was about 30 minutes in when we realized the path was much longer than usual do to where the folder had been nested.------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US-----------------------

Want to prohibit users from using the DELETE Verb from tcl or the Command prompt, but want to be able to use DELETE from Unibasicif there a way that i can tell where the command is being executed fromUsing Unidata system ------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

Greetings, all! We're running UniVerse 11.3.4 on AIX 7.2If I remember correctly from some previous posts, UniVerse has it's own embedded version of openssl that it uses instead of the AIX version.  If that is correct, is there a way to list (or somehow look up) the ciphers that UniVerse is using? We're making https (443) API calls to a middleware server (Windows-based, running Apache Tomcat) from within the UniVerse environment and we're getting the message:    This combination of host and port requires TLS.If we make the calls over http (80), they work just fine, but we need them to be over 443.Our network folks are thinking we might have a cipher conflict (one side or the other not using the same ciphers), but I don't know how to determine which ciphers UniVerse is using.  Any help with this would be greatly appreciated.  Or, if anyone has seen this issue before and knows the solution to the issue, that would be even better! Thanks!Brian------------------------------Brian Paige------

Easter greetings to you  ,Anyone can point me to how to add fields that are in Universe are not showing in our SQL db tables. Please assist show steps to include the missing fields not found in SQL tables for easy access and reporting purposes. Thanks. ------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

I am trying to connect to an API and need some helpUsing RHEL 7 and Universe 11.3.4The curl example they provided works in RHEL. curl -X 'GET'   'https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips?vagusAPIKey=1A2B3C-1533-CMBD-8537-123456789'   -H 'accept: text/plain' This is my BASIC Code      URL = "https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips"      KEY = '1A2B3C-1533-CMBD-8537-123456789'      X = addAuthenticationRule(X.CONTEXT,2, "VerificationStrength", "generous")      X.DEPTH = 2      X.SERVER.OR.CLIENT = 2             ; * CLIENT      X.RTN.CODE = setAuthenticationDepth(X.CONTEXT, X.DEPTH, X.SERVER.OR.CLIENT)      X.RTN.CODE = addAuthenticationRule(X.CONTEXT, 2, "ServerName", "stagingapi.vagustracker.com")      HTTP.METHOD="GET"      X.RTN.CODE = createSecureRequest(U

I can capture output from LIST.READU command as follows:EXECUTE 'LIST.READU' CAPTURING OUTPUTEach row can be extracted by looping through using @am to determine number of rows my question is how can one parse out the individual column fields - what delimiter is used to do parsing oris  the  data in each row  simply fixed length.------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

In UniVerse Basic, if we read a record, not present in a file, with locking (after each read the record is not unlocked), it looks like this: OPEN "VOC" TO VOC ELSE STOP 201,"VOC" READU RECORD FROM VOC,"LISTY" THEN    CRT "1: [":RECORD:"]" END ELSE   CRT "1: NOT ON FILE" END READU RECORD FROM VOC,"LISTY" THEN    CRT "2: [":RECORD:"]" END ELSE   CRT "2: NOT ON FILE" END READU RECORD FROM VOC,"LISTY" THEN    CRT "3: [":RECORD:"]" END ELSE   CRT "3: NOT ON FILE" END Running program, the result is: 1: NOT ON FILE 2: NOT ON FILE 3: NOT ON FILE and is as expected, but if we tray this in UniObjects ActiveX o UniObjects .Net, the result looks like this: 1: NOT ON FILE 2: [] 3: [] Oops!! The first read is as expected but the next reads return an empty record like exiting for the THEN clause rather ELSE. If we unlock the record after each read, the result become: 1: NOT ON FILE 2: NOT ON FILE 3: NOT ON FILE The result is the Basic program. Another stuff to take into account.---------------------

Hello everyone, I am trying to parse a string against a pattern and return a delimited list of tokens.  OpenQM has a Parse() function but there is no equivalent in Universe that I can see.  Has anyone done something similar? For instance, if I have something like below: string = "Give me 97 bananas" tokens = Parse(string, "0X0N0X", Char(254)) I would like tokens variable to contain "Give me ":Char(254):"97":Char(254):" bananas" Any help or suggestions would be appreciates. ------------------------------Joseph von ArxSoftware DeveloperData Management Associates Inc DMACincinnati OH US------------------------------

ODBC Driver. Good day all, thanks for the help with the previous post. Its given me plenty to work on. Along with this, I've had another issue that has risen this week. When Live Partition Mobile'ing a AIX Server, we hit problems with the OCDB driver. Namely that the server moves live with no issue, until you restart UniVerse, then we get license problems. If the server is moved back to the original machine, the license problem still occurs. So it needs to be reset. Now I know that on our Redhat VMware environments this is not a problem, and I'm sure its something that I could fix, but before I re-invent the wheel, I figured I'd ask here. Thanks, ------------------------------Daniel Martin-CorbenRocket Forum Shared Account------------------------------

At Rocket Software we are committed to and value product security.  Rocket Software continually reviews security compliance policies and trends to strengthen our products. We've  recently implemented the Rocket Vulnerability Disclosure Program (VDP) as an added measure of vigilance.  This program allows us to collaborate with valued researchers to respond to vulnerabilities found in Rocket Software products and resolve them on behalf of our customers. Recently, Rapid7 Research discovered several vulnerabilities in Rocket UniData 8.2.4 and reported them through the VDP.  Rapid7 found vulnerabilities with the UniData UniRPC server (and related services) running on the Linux platform.  Due to the nature of the MultiValue applications, Rapid7 believes that widespread exploitation of the vulnerabilities is unlikely; these services tend to be found on the backend and are rarely internet-facing.  That being said, the software stack is commonly used by large organizations to store and manage

In Unidata can you disable the LOGTO verb based upon a user login?------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------