Rocket® U2 | UniVerse & UniData®

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 habit

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_namec

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 ad

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

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 us

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,

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 

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

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 1980

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 acco

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 UniV

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

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

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 U

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 re

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 bl

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 h

  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

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.