Rocket® U2 | UniVerse & UniData®

Unidata 8.2.1 on RHEL - what does this error mean? When it happens the system usually locks up (when udt is started from the .profile) and people can't login until Unidata is forced down with stopud -f and restarted.

If you have become used to stopping PHANTOM processes by killing them or editing a controlling record in a file, there is a much more elegant method available using the often under-recognised method of process locks.For example, if we choose lock 1 to signify that a job is already running and lock 2 to instruct a job to terminate, then the code below can be used to ensure that one - and only one - instance of the PHANTOM is permitted to run at any one time:* Sample code snippet:- PHANTOM job start ** Set the PHANTOM job name *PHANTOM_JOB='WEEKLY_INVOICES_EMEA' ** Designate the locks to be used for this handshake * RUNNING_LOCK=1 ; * the lock number used by the PHANTOM when it is running * * check if the PHANTOM is running by attempting to set the process lock * that it would own if it were already running. * LOCK RUNNING_LOCK THEN * * The controlled job is not running - OK to start it * first release the lock we just set to check if it was already running. * UNLOCK RUNNING_LOCK * * now

I am writing a paragraph to script compiling programs and am creating a log record using the DIVERT.OUT capability. So, the DIVERT.OUT command is set up to be:DIVERT.OUT ON log_file THIS.PARA APPENDI want to add the date to the name 'THIS.PARA' so that the command would be:DIVERT.OUT ON log.file THIS.PARA.<<P,THIS.DATE>> APPENDSo, I am trying to set 'THIS.DATE' to a date in the form of 'yymdd'.i have a program that will set paragraph variables but at this point, that program is not yet compiled and available. Suggestions for a simple way to do this just in the paragraph?Thanks!

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

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

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

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

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

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

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