Rocket MultiValue

Hello there, I need your expert advise please. I am using Universe 11.2.5. I have a report with 83 columns. For each transaction, some of the columns might have a data more than 1000 characters. I try to limit to a maximum of 1000 characters per column . I use the following command:      FOR X = 1 TO 83              IF LEN(COL<X>)  >  1000  THEN                      PRT.RECORD :=  "," : COL<X>[1,1000] This LEN command did not work. in the PRT.RECORD, the content from COL<X>[1,1000] was more than 1000 characters. I also tried the LEFT command.      PRT.RECORD := "," : LEFT(COL<X>,1000) This LEFT command did not work as well. in the PRT.RECORD, the content from LEFT(COL<X>,1000) was more than 1000 characters. Is there any other command to be used for setting a maximum character. Your advise would be most appreciated. Cheers------------------------------Yossy TanAnalyst / ProgrammerToyota Tsusho South Pacific Holdinh------------------------------

I am trying to clarify the upgrade process as some of the documentation I have read some documentation that says to do a fresh install with new drives and that the installer will wipe out existing partitions.  I have read other bits that indicate that you can upgrade with data in place.  I would like to upgrade with data in place (with a good backup of course) but before I destroy something I just want to be sure.  Any success stories appreciated. Steve Caspers------------------------------Steve CaspersMurphy Automotive Inc------------------------------

Hi all, Sorry if this question has been previously asked answered, but I didn't see how to search for a topic. "Server" is Windows 10 running Universe 11. "Workstation" is Windows 10 running various apps and telnets into UniVerse. It has a printer on a USB port and is shared. Server connects properly to the printer and successfully prints a test page. I've checked all the share permissions, and among many others, "everyone" has print and manage privileges. Yet, when I do a SETPTR ,,,[etc] AT \\ENVYW10,HPLJ or AT \\10.1.253.60HPLJ and try to print, I get  Access is denied. Program "BLOCK.PRINT": pc = 2A0, StartDocPrinter failed with error 5 I've tried the usual rebooting, etc, On my old server I seem to recall an entry in the &DEVICE& file, but I am told this is not necessary. Also, the extensible admin utility won't allow the definition of a printer, only a tape drive. Any help will be greatly appreciated! Thanks in advance.

Hello folks,A never answered behavior : how to mix monovalued and multivaluled data into a SREFORMAT result. Here is the a sample uniQuery, SORT + WITH + WHEN + BY.EXP on HS.SALES (demo account into uv)I filter data on STATE (monovalue field) and BUY_DATE (multivalued field) and I display data from monovalued and multivalued field.As expected, with SORT BY.EXP, the monovalued field are replicated on each occurence of multivalued line. SORT CUSTOMER WITH STATE = "MA" AND WHEN BUY_DATE >= "20/01/91" AND <= "29/01/91" BY.EXP BUY_DATE BY CUSTID CUSTID STATE CITY BUY_DATE PRODID ID.SUP Customer ID State City........ Date Purchased Product 8 MA Lowell 21/01/91 M3000 8 MA Lowell 21/01/91 S3000 2 MA Waltham 22/01/91 S3000 3 records listed. ​ so, now I'll send these result to a temporary file with SREFORMAT, which build a record by line of result ; the first column is the key on the temp file.I use the same phrase, replace the SORT verb by SREFORMAT. CREATE.FILE FTEMP 18 53 4 SREFORM

pip is the package installer for Python. You can use pip to install packages from the Python Package Index and other indexes.  pip is required when installing MVIS and we have seen many questions on installing pip when it appears that the Python installation on a system did not include pip.The installation of pip for Python is not obvious and can lead to many questions or support cases to address the installation.  Below is a link to a tech note available in the customer portal to assist in installing Pip to get you started in MVIS:RCP Link: Installing Pip for PythonLet us know if there are any questions about the MVIS installation or the Python/Pip installation.------------------------------Andrew ClayTechnical Support Engineer IIRocket Software------------------------------

Within SystemBuilder there is a process we can use to transfer group security restrictions from one group to another, though this process is little known it has been in the product since before version 6.  We get questions on this topic from customers looking for an easy way to transfer group restrictions within SB and SB/XA but find using the SB security API cumbersome or inefficient.The process in SB is called RESTRICT.COPY and it has not been documented, we have created a tech note on the process to demonstrate a quick and simple solution to transferring restrictions from one group to another.RCP Link: Group Restrictions TransferAttached is the content of this tech note, users may find this useful when managing large systems requiring a number of SB security groups.------------------------------Andrew ClayTechnical Support Engineer IIIRocket Software------------------------------

into the Windows/Universe/VOC,we have DOS defined to start a process cmd.exe (DOS /C 'dir')I'll start a powershell.exe instead of cmd.exe and define a VOC entry PS1 instead DOSthe I'll use it to launch ps1 script execution like PS1 get-childiteminstead stating a DOS/cmd,.exe to launch a powershellDOS /C "powershell -file myscript.ps1 -arg val -arg val "any idea ?------------------------------Manu FernandesInfodata------------------------------

Hello!  I try to build a subrouting that will be used by an I-DESC.  Its goal is to encrypt another attribute, using SHA256.  The DICT item will be used in CSV exports, to transmit data to partners.  They want some columns to be encrypted (it would be too easy to encrypt the whole file I guess).  That is why I want to combine a subroutine with an I-DESC.Okay, so I already wrote my subroutine but I am not sure about the result.  Maybe someone here already did something similar, and/or maybe someone could help me to find the right way to reach my goal.My subroutine is simple: I use DIGEST (beacuse it was the only function that seems to know pure SHA256), and after, I encode the result as BASE64-OneLine, to make it human-readable. MY.HASH = "SHA256" MY.STRING = "HELLO" DIGEST.STATUS = DIGEST(MY.HASH, MY.STRING, 1, MY.DIGEST) FINAL.STRING = "" ENCODE.STATUS = ENCODE("BASE64A", 1, MY.DIGEST, 1, FINAL.STRING, 1)​ The result of the subroutine, fo

We get asked every now and then where to get the U2 client software.  These include:U2 Clients ODBC, JDBC, UOJ and .NET drivers and associated tools Visual Schema Generator SSL Setup Tool Certificate Management Tool Dynamic Connect Intercall U2 DBTools U2 Basic Developer Toolkit U2 EDA Replication Configuration Tool U2 EDA Schema Manager U2 Extensible Administration Tool (XAdmin) U2 Metadata Manager U2 RESTful Web Services Developer U2 XML/DB Mapping Tool These two packages are all available for public download from RBC | Rocket Software - just choose : Resources  Product Availability Choose the Product and 'Search',  either for U2 DBTools or U2 Clients (these will always show as for Windows, though the JAVA clients are multi-platform) Use the 'Product' link under the 'Downloads' column for the version required - this will usually be the latest version. You will now have options to download the Product - which includes the Documentation - or the Documentation only, All Documentat

In June 2020, the Rocket MultiValue R&D team released a new version of SB/XA – version 6.5.6. If you're running the current version of SB/XA, I'm interested in your thoughts about the release. If you haven't upgraded, I'd like to learn what's holding you back.Did you know that we offer a Rocket SB+ Guided Upgrade Tool? This Tool automates the necessary steps for a successful upgrade to release 6. Learn more about SB/XA 6.5.6, including new features that provide real benefits to you including security enhancements.------------------------------Hernando BordaRocket Software------------------------------

Using BIML to create SSIS packages with a UniVerse source connection. I can build a package manually and connect successfully using the rocket ado .net driver. However when attempting to automate the build of the packages through BIML, I receive a failure at the AdoNetSource connection string. The connection string requires a "ServerType" to be defined. When the AdoNetSource attempts to connect using the connection string, it fails with error message "keyword is not supported: 'servertype'". I get the same error when converting a working package to BIML through the 'convert package to BIML' option. When attempting to rebuild the package from the automated BIML script, the same error message occurs with the supported keyword of 'servertype'.  Has anyone come across this before and found a workaround? I need to continue to use the ADO Net provider as it is significantly faster than other options (ODBC and OLEDB). A similar message is posted on the BIML forum as I suspect Varigence does n

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