Rocket MultiValue

Have you thought about changing the CENTURY.PIVOT? The century pivot point is the year used to determine the century when an ICONV is done on an external date that only provides a 2 digit year. Note the following BASIC code will takes a the date with a 2 digit year, convert it to internal format, then display it in external format. >CT BP CPTEST     CPTEST0001 FOR YY = 10 TO 90 STEP 100002 ODATE = "01/01/":YY0003 PRINT "TESTING DATE ":ODATE:0004 IDATE = ICONV(ODATE, "D2")0005 PRINT " --> ":OCONV(IDATE, "D4")0006 NEXT YY >CPTESTTESTING DATE 01/01/10 --> 01 JAN 2010TESTING DATE 01/01/20 --> 01 JAN 2020TESTING DATE 01/01/30 --> 01 JAN 1930TESTING DATE 01/01/40 --> 01 JAN 1940TESTING DATE 01/01/50 --> 01 JAN 1950TESTING DATE 01/01/60 --> 01 JAN 1960TESTING DATE 01/01/70 --> 01 JAN 1970TESTING DATE 01/01/80 --> 01 JAN 1980TESTING DATE 01/01/90 --> 01 JAN 1990   In the above you will notice that two digit years greater than 30 are being treated as if it wa

UniData version 8.2.2 has been released on September 29 2020 for the below platforms/versions: AIX POWER       7.1,  7.2Amazon Linux       2CentOS       7,  8HP/UX ITANIUM       11.31Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Solaris SPARC       11SuSE Linux Enterprise Server Intel       11.0,  12.0Windows       Windows 8.1,  Windows 10 (Creators Update supported),  2012 (R2),  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.asp For any questions on product a

Attached is a small demonstration of what is possible with SB/XA XAML themes.  Adding a hyperlink to SB/XA Screens that open within the default browser.  This is also a tech note, accessible via the Rocket Community Portal(RCP).RCP Link: SB/XA Hyperlinks In ScreensThis tech note details how to create a hyperlink within an SB/XA screen to open in the systems default browser.  Again this is a small demonstration, but there are many things, both of similar scope and larger changes, that can be accomplished via XAML styling in the SB/XA Rich Client.------------------------------Andrew ClayTechnical Support Engineer IIRocket Software------------------------------

MultiValue Integration Server is approaching the first anniversary of its launch, and the MVIS team continues to host webinars, write blog posts, and other technical content for customers and users. One such webinar following in the launch's wake is a deep dive into the newly released platform, hosted by Julianna Cammarano, Zain Master and Steve Wingfield. In this webinar, "Introducing Rocket MultiValue Integration Server" (55m), viewers are guided on a tour of the platform's capabilities, value, integration points and much more. After watching the introduction, you should be well informed to begin your MVIS journey and deploy its functionality. Whether you are new to MVIS, or an experienced veteran, we're interested in your experience. Share your thoughts, tips, and what you learned from the webinar.------------------------------Charles Dane Rocket Software------------------------------

I remember Connectivity Hub (RACH) was part of Rocket Mobile solution where the apps could be uploaded and shared whatever with general users or with company's internal users. Also it had very powerful features like device identification, so in case a device with a sensitive app was lost or stolen, we could disable the app access on that specific device. Now we have MVIS and more mobile apps can be developed to empower company's users but these apps don't need to be published either in Google Play or Apple Store because they are important only for internal use or specific customers.So this is the idea, turn Connectivity Hub into a company's private Apps Store where apps could be uploaded, managed and shared with company's users or specific customers. For example, a company could have a variate of apps for different areas and users.This is just an idea and it would be good to know other opinions.------------------------------Jaime LunaALCOMTEC EIRL------------------------------

It has been very frustrating when the changed Universe 12.1.1 to no allow updating indexes while people are accessing the file. This worked before from 9.6 to 11.3.1 but not 12.1.1. We have clients that run 24/7 and we have to stop our Web-based applications running under Apache Tomcat, make sure no one is using our Eclipse IDE tools and kill any phantom jobs before you use CREATE.INDEX. Otherwise, you get this:>CREATE.INDEX ACCT.CHECKS BANK.NO NO.NULLUnable to open "ACCT.CHECKS", file open by other users, exclusive access failed.Here is what Rocket said in my case:Advice from our ATS engineer:Reverting functionality to how it was prior to UniVerse 12.1.1 can cause issues where a newly created and built index can be out of sync if existing users have the file open. As long as our customers acknowledge the risk, we could create a new story which would allow customers to have their installation behave as it was prior to UniVerse 12.1.1 if they choose. This would be something that is c

This Universe compiler has been doing this for many years and you should have fixed this so the error message is usable. I had hired new U2 programmers and trained them in Universe but they were very frustrated with these errors and rightly so.Maybe they missed a reserved word or two!Top.*--: P001: OPEN '','VOC' TO VOC ELSE STOP 'VOC'002: READ DUMMY FROM VOC,'DOUG' THENBottom.*--: FIBFiled "DOUG" in file "BP".Compiling: Source = 'BP/DOUG', Object = 'BP.O/DOUG'000003^End of File unexpected, Was expecting: Array Name, Variable name,New variable name, ';', Statement label, "ABORT", "ABORTE", "ABORTM","BEGIN", "BREAK", "CALL", "CHAIN", "CLEAR", "CLEARCOM", "CLEARDATA","CLEARFILE", "CLEARPROMPTS", "CLEARSELECT", "CLOSE", "CLOSESEQ","COM", "COMMON", "CONVERT", "CREATE", "CRT", "DATA", "DEBUG","DEL", "DELETE", "DELETEU", "DIMENSION", "ECHO", "ERRMSG", "ENTER","EQUATE", "EXECUTE", "EXIT", "FILELOCK", "FILEUNLOCK", "FLUSH","FOOTING", "FOR", "GET", "GETX", "GOSUB", "GOTO", "GROUPSTORE","HEADING"

Are you a current user of U2 ODBC and/or JDBC with UniData 8.2.1? If so, it is necessary to ensure all accounts are using the 6.0 version schema files. Not doing so runs the risk of some applications not working with your UniData account.In his blog, Paul Chang provides an overview of account creation, recreation, upgrade and management of schema v6.0 files, and new UniData accounts in this environment.Learn more in the "Using UniData 8.2.1 with v6.0 Schema Files" post.------------------------------Charles Dane Rocket Software------------------------------

Despite being a version behind 12, UniVerse 11.3.2 is still a feature-rich platform with plenty of enhancements. Earlier in the year, myself and members of the UniVerse team hosted a webinar about this version of the application server.In the "Rocket UniVerse 11.3.2 Deep Dive" webinar (49 minutes), you will be introduced to an overview of the product before taking a closer look at new features and enhancements made to current features. Finally, demonstrations of these new features and enhancements are shown, including sequential file replication, UTC date time, Geospatial, root certifications, and more.------------------------------Chris RizzaRocket Software------------------------------

Hi, We currently have UniData 8.2.1 running on RHEL 6, but RHEL 6 is 'end of support' in November so we would like to migrate to RHEL 8, if support for UniData is available for it.  I heard that Unidata 8.2.2 would support RHEL 8 and that it was due July 2020.  Is there an update to its expected release?------------------------------Thank you and best regards,Don Wolfe------------------------------

In the current age that demands very quick turn-around times to meet customer requirements, it is essential for every company to revisit all aspects of software development, including requirements gathering, development and deployment. In these times, tools that optimize and simplify software development are increasingly important.Swagger, one of these tools, allows developers to easily create REST services and showcase them to both internal and external stakeholders via public APIs and speed up the pace of collaboration to develop web applications.Watch the short Viewing and exercising Swagger Definition video to see how Swagger, embedded in MVIS, helps you quickly create RESTful APIs for your MultiValue data and business logic. We hope you enjoy this video. Please share any feedback or ideas for new content, and reach out if you need any help.------------------------------Amey RokdeRocket Software------------------------------

Hey, folks, have you ever considered having Rocket perform a health check on your D3 system? If so, check out this link to the D3 health check datasheet.Then if you're interested, please reach out via email to our Customer Solutions Engineering team and they will be happy to lend a hand. Remember, it's better to catch something BEFORE it brings your system to a screeching halt!------------------------------Brian CramSenior Technical Support EngineerRocket Software------------------------------

Are you new to Rocket MultiValue Integration Server? This short video will get you on the way to creating your first MultiValue RESTful service. In a few steps you will learn how configure MVIS to add access to a UniData or UniVerse account, configure and test connectivity to it, and start the MVIS server.Follow the link and start your journey with Rocket MVIS.------------------------------Hernando BordaProduct Manager, MultiValue ToolsRocket Software------------------------------

Rocket UniVerse 12, a Rocket Multivalue Application Server, has been rearchitected to provide the ability to better handle heavy workloads and improve data integrity, reliability, and accessibility. The new Recoverable File System (RFS), along with replication, completes the UV 12 HA/DR strategy. With RFS, enterprises can restore to the last complete transaction in the event of unexpected outages. UV 12 includes core performance and integrity improvements by delivering query optimization, accelerated transaction processing, and much more.  In the "What's New in Rocket UniVerse" video (~3 minutes), you will be introduced to the new features and enhancements included in UniVerse 12. Click here to learn more about Rocket UniVerse and supporting UniVerse products.------------------------------Chris RizzaRocket Software------------------------------

Rocket UniData is a best-in-class part of the Rocket MultiValue Application Platform for scalable business apps that can evolve as needs change. As a stable, secure, fast data server engine, Rocket UniData is ideal for rapid development using modern tools. Watch the "What's New in Rocket UniData 8.2" video (~3 minutes) to learn about new enhancements and improvements, such as Python support, new audit logging, faster replication, and better report management. Visit the Rocket UniData product page to learn more about UniData and other supporting products.------------------------------Chris RizzaRocket Software------------------------------

Emergency responders face daunting challenges with each day, especially in light of recent events. While EMTs, fire fighters, police officers and even utility workers present the public face of first responders, all are assisted by support and dispatch teams utilizing a complex infrastructure to manage assets, resources and information.Pulsiam is a leader in the development of emergency response systems. Technology has advanced from hand-held radios to mobile phones, whiteboards to real time GPS tracking, and more. With Rocket UniVerse at the core of their portfolio, Pulsiam has had the foresight and agility to integrate technology into their products often long before industry competitors have.To learn more about Pulsiam and their use of Rocket UniVerse, read the Legendary Help: Saving the Lives of Emergency Responders blog.------------------------------Charles Dane Rocket Software------------------------------

Rocket D3 10.x is a powerful tool for database managers, offering improved reliability, security, performance, and modern functionality than previous versions. The end result is more streamlined management and increased productivity. The "What's New in Rocket D3" video (~4 minutes) will introduce you to the latest features and enhancements included in D3 10.x. Older version users may upgrade at no cost to receive these and many other benefits. Click here to learn more about Rocket D3 and other products in the D3 family. What feature or enhancement has proven itself most valuable to you? ------------------------------Tim RudeRocket Software------------------------------

Our new Rocket MultiValue Integration Server is the vehicle to expose MultiValue data and logic as RESTful services and enable integration with modern web applications and services. Watch this short video demonstrating how to easily leverage MultiValue data using MVIS REST services and a native Android/iOS mobile solution written with the Flutter framework and the Dart programming language, an open source solution from Google, for building mobile applications. The demo shows how you can build on your existing investment while benefiting from augmenting your environment with the latest technology, which can live side-by-side with your existing MultiValue applications – even for apps that still use green screen. ------------------------------Safwat BoulosRocket Software Inc.------------------------------

I've been looking into Docker with a view to using it with MVIS. The manual is very short on examples, only covering using Azure for storage.I did see the deployment scripts, but these also lack any documentation.Does anyone have examples of MVIS working with docker local storage?------------------------------Jonathan EvansMBS------------------------------

In the previous article “Dealing with the Python time module from Rocket MV BASIC” I showed how it is possible to access the python internal time module and convert the python date to string display format, then convert it back into the number of seconds since Epoch.    Python RESULT: python time= 1418146291 Python RESULT: python local time= Tue Dec  9 09:31:31 2014 Python RESULT: python time= 1418146291   While it is possible to write a subroutine to handle the interaction between MV BASIC and Python, you can get more from you subroutine if you write it as a User Defined User Exit.   User exits are the codes used in the ICONV and OCONV functions.  In the first article of this series we showed how we can call the u2py.DynArray.iconv and u2py.DynArray.oconv functions to convert display dates into internal format, and then convert back into display format:   python> test = u2py.DynArray("04 Dec 2014") python> itest =  test.iconv("D") python&g

  I the previous post “Dealing with Internal and Display format data in your MV database with Python” I showed how it is possible to convert the python date to the MV internal format.  We will not show how we can get the python time date representation.  In the time.time() function returns the number of seconds since the Epoch.  The Epoch is a system defined date.   python> time.asctime(time.gmtime(0)) 'Thu Jan  1 00:00:00 1970'   By having the number of seconds from a specified point in time, we are able to generate a display value that has both the time and the date.  This is different then what MV provides, which is q date value and a separate time value.   What we now need to show is how to get the python time values into a MV BASIC program.    The first thing we need is a module that contains the functions we want to expose to the MV BASIC programmer.    python_time.py # Example module used in article that describ

Rocketeer Kirsten Petersen, Information Developer for MultiValue products, recently penned a blog post on the merits of upgrading older versions of Rocket D3 to the latest version, 10.3. Data security, improved performance, wider compatibility, and terminal device integration are just a few of the benefits offered by the newest release.Rocket mvBase customers may also benefit from a migration to D3.To learn more, visit Kirsten's blog post!Have you updated to the latest version of D3, and if so, what benefits have you discovered?

Managing product marketing for the MultiValue business unit means that I have an opportunity to interact with customers, and hearing how Rocket products have improved services and offerings for their customers.Using a combination of UniData and U2 RESTful services, Fudtrak has created a mobile app allowing users to locate, view the menu of, call, and socially engage with their favorite food trucks. Fudtrak's sister app, Fudtraker, handles "back of house" and social management for truck owners.To learn more about Fudtrak, Fudtraker and UniData, visit my blog post. You can also read the more recent Alcomtec case study.#UniData

Earlier in the year, Cheng Jiang, one of Rocket's software engineers on the MultiValue team, shared some insight into OpenSSL and this new Transport Layer Security protocol inclusion in UniVerse 11.3.2.To learn more about the new Open SSL library, improved SSL protocol support, support for new cryptographic algorithms, and more, visit his "Things You Need to Know about OpenSSL 1.1.1" blog post.Have you made the upgrade to UniVerse 11.3.2 (or UniData 8.2.2, which also received the OpenSSL update)? How has the newest version enhanced your security?#UniVerse#Security

With close to 250 thousand projects on https://pypi.org/, it is not likely any of us will have a chance to try them all. Please reply to this discussion with a short comment on any python module/package you feel would be of interest to the group. For example: Recently, Louis Tur and I published blog posts on using Twilio to send SMS Text Messages. How to Send SMS Text Messages from U2 with Python WHY SEND SMS TEXT MESSAGES FROM U2 WITH PYTHON------------------------------Michael RajkowskiRocket Software------------------------------