Rocket MultiValue

Our devops team was  performing a system upgrade from Linux Ubuntu 18.04 to 22.04 late last night.  When they completed the migration, they discovered to their horror that the SystemID had changed.   Not knowing what to do at that hour of the night, they searched for a solution.  They found a link  posted by Martin on the Google Groups: www.openqm.com/emergency.htm   They provided the required information and received the following back: 1. We are concerned that after 7 days pass, this license will expire.  Can someone confirm?2. What is the correct action to take?  Our upgrades are going to take place off-hours, late in the evening.3. Is this expected behavior that an O/S upgrade will change the system ID? Any advice is appreciated.------------------------------Ben Cramer DSI Solutions LLCMansfield TX US------------------------------

Hi,Can someone help for downloading JDBC driver for accessing from UNIX Server (as Client) to Universe DB?------------------------------Elayaraja KathirvelRocket Forum Shared Account------------------------------

I have this audit file that cannot be selected, counted, or cleared. I am running Universe 12.1 in Windows 2016. Generally, this audit file gets purged daily using date criteria of 90 days back, however, I just noticed the select never comes back. I was able to kill the indexes and was hoping that was the problem, but that was not the case. I should point out that I can add more data to the file with writes but not much else.Besides creating a new file and renaming this one, has anyone seen something like this?Posted 08-27-2022 11:43------------------------------Doug AverchOwnerU2 Logic------------------------------

I have several customers who need real-time sales tax calculation. Has anyone integrated an online sales tax calculator with D3 and is willing to share the code?------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Hy... does anyone use SNMP to monitor d3 in linux ? to monitor memory use, disk use and other things... if yes... how ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

hy  i use  the follwing select  :select sgvar614 if a9999 eq "^^^"[401] no items present. but sometimes takes to long...  and i was think... is possible create a index for that ... for exemple CREATE-INDEX SGVAR614 A9999 it would continue acctin as funciction to size.. or would do as the attribute ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

sorry to post this again but for some reason I could not post a follow up question to derek's response, is xadmin the ONLY way to create accounts in unidatathanksdougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Please excuse a basic question. but is it possible to delete an item from a select list like you can with an array?SelStr = ' WITH ORD.CODE = "A"  AND ORD.SHIP.DATE < "1/01/2023"'XCmd = 'SSELECT ORDERS' : SelStr : ' TO 1'CRT XCmd ; EXECUTE XCmd  LOOP    READNEXT ORD.ID FROM 1 ELSE EXIT          IF ORD.ID = 12192209 THEN      DELETE ORD.ID FROM 1?????         END   REPEATEND------------------------------Matthew WrightAnalystTomago Aluminium Co PTY Ltd.Tomago NSW AU------------------------------

I've been trying to write an ATGUI program using the data grid.  I want to change the row colors on some of the rows but not all. I was able to do it using the ATGUISETPROPS subroutine but it's pretty slow.  My grid displays that data quickly enough by filling it in with the ATGUISETPROPS and loading them all at once. There are only about 30 rows.  After they're displayed I make a second pass highlighting the special rows. It pops up the "Waiting..." dialog and you can watch the colors flow down.Is there anyway to set multiple row colors all at once like ATGUISETPROPS?When I refresh the grid with new data the highlights stay there. I tried setting all the foreground and background colors for the entire grid by using ATGUISETPROP and setting the col and row values to zero. I couldn't get it to work so instead of just setting the highlight colors I have to reset them all for each row whenever I load new data. Is there a better way to re-initialize the grid colors?Finally, is there any wa

There was an SQL optimization error in 3.4.7 caused by using wildcard characters in your WHERE clause. This build fixes it. If you want this latest version, please contact D3 support and we'll get it to you.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

We ran into this recently and I thought I'd share. In the legacy/character version of our software, we normally prompt for dates using a two digit year (mm-dd-yy), iconving and oconving as needed.  Recently, a user entered "12-31-33" as a date.  The iconv returned -12418 (12-31-1933) rather than the expected value of 24107 (12-31-2033).  After researching this we discovered that Pick/Rocket and QM both default to dates entered with 2 digit years greater than 30 to be in the 1900's, years less than 30 as assumed to be in the 2000's  Note: iconving a date with a 4 digit year always returns the correct value..  QM does have a config setting that will allow you to override the cutoff, however rather than remembering to change the config setting every few years on every user system, we opted to add code to our legacy system that checks the iconv'ed value and adjusts it as needed.------------------------------Ben CramerOwnerDealer Solutions LLCMansfield TX US------------------------------

We ran into this recently and I thought I'd share. In the legacy/character version of our software, we normally prompt for dates using a two digit year (mm-dd-yy), iconving and oconving as needed.  Recently, a user entered "12-31-33" as a date.  The iconv returned -12418 (12-31-1933) rather than the expected value of 24107 (12-31-2033).  After researching this we discovered that Pick/Rocket and QM both default to dates entered with 2 digit years greater than 30 to be in the 1900's, years less than 30 as assumed to be in the 2000's  Note: iconving a date with a 4 digit year always returns the correct value..  QM does have a config setting that will allow you to override the cutoff, however rather than remembering to change the config setting every few years on every user system, we opted to add code to our legacy system that checks the iconv'ed value and adjusts it as needed.------------------------------Ben CramerOwnerDealer Solutions LLCMansfield TX US------------------------------

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

We hope you can join us! The only way to learn about all that's to come in 2023 and beyond is by being there! Please note we don't record these roadmap livestreams, so you must tune in live if you want the inside scoop on all things MultiValue. Register now to join the MultiValue product management team as they host a livestream of our Rocket MV product roadmaps: Each Rocket product manager will present on both near-future and distant-future plans for his/her MV products, as well as the many possibilities they're still considering. Participate with us and each other using Slido, an easy-to-use Q&A app, to make the event more interactive. Hear more about eLearning, including our rollout in Q1 Get updates on our MV cloud roadmap, Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, jBASE, OpenQM, AccuTerm, and MultiValue tools including MultiValue Integration Server (MVIS) and our MV Experiences (MVX). We know our roadmaps affect your application and that you must plan internal upgrad

if not is there another way to handle moving files from one OS to anotherthank you dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

I'd like to use Adds Viewpoint enhanced, it works well with my application except - when my application switches from 80 to 132 column mode, it changes the emulation to VT100.  I haven't found the right place to tell me how to fix this.TIA,Bruce------------------------------Bruce AckmanVice PresidentLewis Supply Co IncRichmond VA US------------------------------

We are currently running UniData 8.2 on AIX 7.1 on soon to be Power10 IBM servers. We have roughly 2000 connections across "4" UniData instances linked by NFS and NFA data pointers sharing a pool of 22 Power server cpu running at smt8.Our management wants to look into moving to a cheaper Linux environment and I am trying to gauge how good or bad of an idea that is and what that would look like vs our AIX setup we have been running for 25+ years.We also have over 2000 AIX user accounts on each system, several hundred AIX printer queues, thousands of programming calls using and parsing output from various AIX commands. If we drop this on Linux, what programming changes would need done to make the code run, outside of all the AIX vs Linux OS command vetting?If you have a large UniData environment, I'd love to get on the phone and chat if anyone is up to it? Maybe even do a meet and great and see how your environment looks vs ours. Some knowledge sharing.------------------------------Tom V

Hy all i have field for cars license plate ... but users input data all the differents waylike for exemple: QAA.6814 QAA-6814 QAA 6814 QAA/6814 QAA6814 how to create an index so i can search the data... but ignoring the .-/ (space)  ???------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

UniVerse version 11.3.5 has been released on January 05 2023 for the below platforms/versions:AIX POWER       7.1,  7.2AlmaLinux       8CentOS       7,  8HP/UX ITANIUM       11.31Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Rocky Linux       8Solaris SPARC       11Solaris Intel       11SuSE Linux Enterprise Server Intel       12.0,  15.0Windows       Windows 10,  Windows 11This 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 availa

Relatively new to Accuterm but have an issue I've inherited from the last programmer....when using the 'required' option for data fields, attempting to close the screen with the top right screen 'X' returns the message that the field is required.  The documentation says the code should hit the validate and deactivate after the 'close' call but it doesn't seem to....as my debugs are not executing.I don't want to have to manually check / set required fields for every click - but I do need to allow the user to exit with the 'X' (CLose) feature without the error message.Anyone know what I might be doing wrong here? How do I keep the 'required' error from displaying when the top right X is clicked, while keeping that field required for all other clicks?Thanks!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Is there a way to find out what Universe program or lines of code that are being executed by a user via universe or Linux commands?------------------------------[Gary] [Rhodes] [Universe Developer][NPW Companies][Hialeah] [FL] [USA]------------------------------