Rocket MultiValue

Hello!  My name is Steve Wingfield, Principal Software Engineer at Rocket, and I'm going to give you a general overview on some of the fundamental concepts MVIS uses, such as REST and Swagger.  I'll also demo our Rocket MV Developer Edition, which is an AWS image you can leverage for free through the AWS marketplace.  In these sessions, I'll share examples of data and subroutines exposed as RESTful services and create a front-end UI using React.    Note: The video playlist below can be accessed using the menu at the upper right of the frame. Click the icon to access additional videos in this series.#MVU #MVIS #Modernization ​​​------------------------------Steven WingfieldRocket Software------------------------------

Hi!, I'm Brian Cram, Rocket Senior Technical Support Engineer,  and I'm going to take you on a journey to discover Rocket D3® 10.3.1, specifically for Windows users.  We'll be covering how to upgrade to D3 10.3, and Senior Manager of Software Engineering, @Tim Rude@Tim Rude will take us through a closer look at some of the performance gains we've made on Windows platforms. Tune in next week when Tim takes through how to install D3 on Unix platforms and the performance gains on Unix. Note: The video playlist below can be accessed using the menu at the upper right of the frame. Click the icon to access additional videos in this series.#MVU #NewRelease #Upgrade #Performance ​​​​​​​------------------------------Brian CramSenior Technical Support EngineerRocket Software------------------------------

Hi, I'm Zhuo Liu (Joanna), Rocket Automation Team Scrum Master, and I'm going to showcase the details of our DevOps efforts to ensure consistent quality in our data server products including: Continuous integration smoke tests and regression tests Conversion of manual test cases to automated tests Automation enhancements such as bringing flexibility to existing auto cases and Smart Installer Whether you’re interested in our efforts to release quality products or if your organization is looking to make the switch to Agile product development, there’s plenty of great information in this MVU virtual event.   Note: The video playlist below can be accessed using the menu at the upper right of the frame. Click the icon to access additional videos in this series.#MVU #DevOps #UniVerse #UniData #Performance ​​​​​ ------------------------------Joanna LiuEngineer in TestRocket SoftwareDalian+8641139404648------------------------------

We have been requested by our Accounting folks to move quarterly report printing to pdf output to eliminate the need to print hardcopy reports.  Does anyone have experience in doing this and how were you able to make it happen?   We run D3 V10.2 on a Windows 2012 server.------------------------------Cory BelgradeSr ManagerOne America------------------------------

Hi, my name is Zain Master, Rocket Software Senior Product Manager, and in this session, I present an MVIS product overview including: ·         MVIS Features / Capabilities ·         Why MVIS is the future of U2REST & Web DE ·         MVIS Roadmap ·         MVIS Trial Software & Additional Resources to get you ready for upcoming hands on sessions   Since this video was published, I have transitioned over to managing MV Experiences. @Hernando Borda has taken over the product management of MVIS.  If you have any questions, please reach out to him directly.#MVU #MVIS #Modernization #NewRelease   ​​​​​------------------------------Zain MasterRocket Software------------------------------

Hi, my name is Chris Rizza and I am the Product Manager for the Rocket MV Databases. UniVerse 11.3.2 was launched in early 2020, but in case you missed it, here is the overview video highlighting some of the major performance, usability and security improvements we have made.  In this video, myself and Advanced Technical Support Engineer, @Neil Morris, highlight and demo the following features:  New Features Sequential File I/O replication UTC Date Time Geospatial support  Security OpenSSL 1.1.1 features Self-Signed/Default Root Certificates demo  Python Python v3.7 Windows, Linux, AIX, Solaris Python performance improvements  External Database Access Support for MySQL and PostgreSQL Datetime field support EDA file size reduction  Supportability Linux 8 certification #MVU #UniVerse #NewRelease #Upgrade #Security #Performance ​​​​​​​​​​------------------------------Christine RizzaMV Product ManagerRocket Software------------------------

I need someone to help me through setting up EDA replication on a UV/Windows server connecting to SQL Server.  The documentation doesn't seem to make sense and I can't figure out how to make it work.------------------------------Kevin KingPresidentPrecision Solutions, Inc.------------------------------

Hi all.Hope someone could share some light on this for me.I'm calling an API in Python using Basic to fire the call ( WooCommerce ) I then receive a JSON Response in the below format [ { "id": 799, "name": "Ship Your Idea", "slug": "ship-your-idea-22", "permalink": "https://example.com/product/ship-your-idea-22/", "date_created": "2017-03-23T17:03:12", "date_created_gmt": "2017-03-23T20:03:12", "date_modified": "2017-03-23T17:03:12", "date_modified_gmt": "2017-03-23T20:03:12", "type": "variable", "status": "publish", "featured": false, "catalog_visibility": "visible", "description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.</p> ", "short_description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac

We have converted a number of our files from 32-bit to 64-bit over that last couple of years. Typically, that has been done when we have a write issue and react to the specific problem. Does anyone have a dictionary or programmatic means of identifying the two type of file so that we can target conversion proactively?Once the files are identified, they can certainly be resized to 64-bit via a script.------------------------------Jeff TeterWoodforest National Bank------------------------------

Good afternoon,  I am wondering if the ability to send keyword arguments into PyCallFunction/PyCallMethod is something being added into a future version of UV? Does anyone have any insight as to when something like this might be added?------------------------------Nic DavidsonCombined Transport------------------------------

Hello,I am receiving an error code 2 when trying to use the createRequestHeader function.:Source:    stat = setRequestHeader (restPUT, 'Authorization', 'Basic ':AUTHORIZATION.STRING)The REST API I am working with uses an API KEY that is created and converted to base64 and added to the "Authorization" header.  I am receiving the correct response when I test in the Postman software, but cannot get the Universe code to work.  I do see in the documentation that the it seems to be expecting the "normal" format for basic user authentication of user:password.  My guess is that is what's throwing the error as my API KEY is just a long string of characters.  Lastly, I am running Universe v11.3 running on AIX.  Please let me know if you need any other information.Thanks,LarryFrom the documentation:This function supports Base64 encoding for Basic authentication. If header_namecontains either “Authorization” or “Proxy-Authorization,”the header_value shouldth

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