Rocket MultiValue

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------------------------------

Please could some boffin convert the following f-correlative into a maths formula with appropriate parentheses (brackets) AI was close but not good enough! F;0;(TPAMASTER;X6;;7);"2";0;(TPAMASTER;X5;;7);*;+;"3";0;(TPAMASTER;X4;;7);*;+;"4";0;(TPAMASTER;X3;;7);*;+;"5";0;(TPAMASTER;X2;;7);*;+;"6";0;(TPAMASTER;X1;;7);*;+;"7";0;(TPAMASTER;X2;;45);*;+;"19";+;"29";/;"300";*;"2";/;"90";+;"100";/ I can fathom the first part to be (7.6 + 7.5 x  2 + 7.4  x 3 + 7.3 x 4 + 7.2 x 5 + 7.1 x 6  + 45.2 * 7 + 19) / 29 => where 7.6 is attribute 7.6 of file PAMASTER, etcBut I just cannot fathom the rest with the correct brackets. Help! :))------------------------------Roland Von HoesslinOwner/ManagerCrystal LogicCape Town ZA------------------------------

Where could I download a JDBC driver for jBASE?------------------------------Clark BradleyRocket Forum Shared Account------------------------------

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------------------------------

At the risk of being told "You should not do that!", I'm working with a 35 year old code base that has been on Pick, AIX and Linux over the years. So, folks decided to used characters like asterisks ("*") and question marks ("?") in item ID's as delimiters. When archiving these items and moving them from Linux to Windows, I have functions for converting the ID's to URL's and back. However, these items will not move cleanly from the Linux folders to Windows folders. So, the question at hand is whether there's a good option for converting those item ID's in flight. Unfortunately, there are too many places where those ID's are embedded in code to go down the path of fixing them all, even though that might be preferable. An aside, WinSCP has implemented nice functionality that makes these conversions when moving from Linux to Windows and back...------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

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------------------------------

HELP! Running jBase 5.8.5 on Windows.  No recent changes to operating system or hardware. Making minor code changes in an order entry program that we've run for years. Modified code, re-compiled and re-cataloged six times this morning.  After last re-compile the program no longer processes any of the file READs in the program!!!   Put an "on error" capture on the READ commands and get error message "file not found".  Files are there and will LIST correctly.  Other programs can access and read the files. jDiag attached. All help will be appreciated as we are dead in the water without the order entry system!  Marc Zitcer ------------------------------Marc ZitcerPresDavidson SupplyPaterson NJ 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

I feel like I must be missing this but have been unable to find it in the documentation.   Is there a way to set the focus to a particular grid cell in code?   I have a grid with a selection box.  If the user selects a given row I would like to take them immediately to the text box in column X on that row for input.  Thanks.

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------------------------------

It appears that the Personal version of OpenQM  does not support printing - Is that correct (I can't seem to make it 'work' if it does)?------------------------------Gary------------------------------

 We love our mvBase customers and wanted to take this opportunity to provide you with some important details. First and foremost, mvBase applications will continue to be supported While we are moving mvBase through our Product Lifecycle to End of Limited Support in September, this simply means support is available but restricted.  Also, you can still renew your maintenance contract. Rocket Software customers on maintenance are entitled to obtain product upgrades at no additional charge (if new versions are available). To learn more please see the Product Lifecycle Announcement that we updated and shared via email in Sept. 2022, 12-months before moving Rocket Software MultiValue products to new stages in the Product Lifecycle.  Additionally, the Product Lifecycle Definitions and our Product Lifecycle Policy are available on the Rocket Business Connect. Second, mvBase customers have optionsWhile Rocket Software would love for our mvBase customers to migrate to another Rocket MV applicat

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-----------------------

New to Jbase with a background in ADP's Reality. The problem I am having is that items within a COMMON area are not transferring to subroutine. The original system was as follows:program A - $include commons os.inv ( this program sets many variables set within the include )--calls program B - carries the same include of os.inv, it does reference a common variable, but otherwise does not set any----calls program C - carries the include, references a common variableI have basically created the following:program A--program B----program D  - new program, has the same include, but the common variables are not assigned??------program Cno idea why program D, despite being a subroutine and having the same include, has unassigned common variablesAlso, was curious if there was a way to view a program which included the code from the includes. In ADP's reality, they had a command called BLIST with the option of (MEL that would give you a listing of the entire program, with included code, and form

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------

I'm seeing something strange and I'm not sure what to check next. We have 2 subroutines that work fine (both are called hundreds of times a day), but then on a certain date, both start throwing this message. The error looks like this:I've changed the sub names and parameter names.Unable to perform CALL to subroutine SUBROUTINE.ONE , Line    81 , Source CALLING.PROGRAMPress C to continue or Q to quit                                                Trap from an error message, error message name = SUBROUTINE_CALL_FAIL           Source changed to /data/app/path1/path2/program_dir/CALLING.PROGRAM0081 CALL SUBROUTINE.ONE(PARAM1,PARAM2,FILE1,FILE2,PARAM1,FILE3,FILE4,PARAM2)  This happened first back on 10/20/22. To fix I simply recompiled the subroutine, in this case SUBROUTINE.ONE and it worked fine until this week and it happened again.What is odd is another sub started throwing the same error on the same day and recompiling fixed that one also. That one also broke again at the same time aga

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

Hello,Has anyone used any of the available migration tools to migrate away from CentOS v7 to either RockyLinux or AlmaLinux?I just came across the AlmaLinux Elevate Project and am wondering if it is worthwhile to try it.As a secondary question, which of the two distributions is preferred?Vincent