Rocket MultiValue

Hello everyone,Firstly, I have to say that this is my first experience of attempting to use UOPY so please forgive any obvious mistakes on my part.   The issue which I am looking for some guidance on is as follows:I can log into Universe via an ssh terminal, issue command such as:SELECT CDC.CARD WITH ID = "1234567890123456" TO 1LIST CDC.CARD CARDNUM FROM 1This selects one record into list number one and outputs the ID and CARDNUM values.   CARDNUM Is a calculated field and is decrypted / displayed correctly when the operations are performed as above.However, when using UOPY, I replicate the above using something similar to the below:cmd=uopy.Command(f'LIST {filename} CARDNUM FROM {list_number}',ses) cmd.run()Inspecting the cmd object shows that there's an error in decrypting the value, with the full error message as follows:error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:crypto/evp/evp_enc.c:570I understand that the Command objects should be

Greetings, all! I used to know this answer, but I haven't worried about it in so long I can't remember.Our data is masked with extra decimal positions.  For example, 1.35 may be masked with 2 decimal places and stored as 135.  When using this data for output, which is better performance-wise - OCONV or dividing by 100?Thank you!------------------------------Brian Paige------------------------------

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

If you are a current user of Rocket wIntegrate, I'm interested in hearing from you. What version are you on? What do you like or dislike about it? Are there any enhancements, features or improvements you'd like to see that would make wIntegrate an even better MultiValue tool for you? In case you are using an older version and missed the announcements earlier in the year, we were proud to announce the release of wIntegrate 6.4.4? To learn more, read the wIntegrate 6.4.4 release announcement to find out how to update to the latest version. Already a 6.4.4 user? What feature have you come to appreciate most?  ------------------------------Hernando BordaRocket Software------------------------------

Rocket Software and the MV team are proud to announce the release of D3 10.3.4 for the Windows and Unix platforms.  This is a maintenance release with over 100 bug fixes.  It also adds support of the newer operating systems like Redhat 9, AIX 7.3, and Windows 11 and Server 2022.  See the Release Notes in the Download page on the Rocket Customer Community site for full disclosure. ------------------------------Bryan GlassickSr. Technical Support ManagerRocket Software------------------------------

Hi,I need to increase space on a customer's D3 Linux 10.2.0. Current disk statement in Pick0:rawdisk offdisk /dev/mapper/rhel-pick 0 209612800 # disk 0They have added a new partition to the VM - so 2 questions.First is it as simple as running the D3setup utility,  adding the partition, and then restarting D3?Secondly, could we have just increased the current partition?Excuse my ignorance around VMs & virtual disks - used to set up small servers with sda1-4 etc - a bit rusty now!Here's the lsblk lsblk NAME                  MAJ:MIN RM  SIZE RO TYPE MOUNTPOINTfd0                     2:0    1    4K  0 disk sda                     8:0    0  500G  0 disk ├─sda1                  8:1    0    1G  0 part /b

Will this be fixed in a future version?------------------------------Jan Van SchalkwykSenior Analyst DeveloperHeritage BankToowoomba QLD Australia------------------------------

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

I am currently using VSCode using the Remote SSH tools and modifying code on the server. The repository on the Linux server is actually configured as a git instance.It's my understanding, using the MVVS extension, the git repository is on the user's PC or shared drive (OneDrive) but the files on the Linux server are not actually a git repository. The net result of this is that the version of a program on the server is always the latest saved version, regardless of branch.It appears that this SFTP extension works well for keeping items in the local repository uploaded to the server. Any other suggestions?This could actually simplify life to some extent. The cautionary tale is that if someone modifies an item on the server side, it must be manually pulled back to the user's repository. Or, is there an "automagic" means of doing that? Also, any items ID's may need to be converted to URL's if they include characters such as '*', '\\', etc.Thanks, in advance!------------------------------Je

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

Just wondering if anyone is using the WOBJ programs to work with JSON objects?   What has been your experience?   Have you found any help documents or tutorials on using WOBJ? It seems that we need a easy way to take multivalue object that we all love and send to a program to create JSON from file and then take the JSON and save to a file.  Have created a dictionary driven tool that works with the older nwbuildjson subroutine but it has limitations when trying to add arrays of objects into the json. Just wondering if anybody has found a pick solution?   ------------------------------Craig CurtisSystem ProgrammerSevier School DistrictRichfield UT US------------------------------

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

Our program uses a pre-compile routine which modifies the code before running the BASIC command to create the object code. Since Rocket MVVS appears to call the BASIC command when compiling, I'm wondering if there might be a way to call our pre-compile routine instead of BASIC.We're in the process of adopting Git and this would help us take full advantage of Rocket MVVS.Thanks in advance for any ideas.

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