Product Forums

Paul Chang June 20, 2018 External Database Access (EDA) enables you to convert data stored in a Rocket UniVerse and UniData database to a first normal form (1NF) database, such as Microsoft SQL Server, then access that data using existing UniVerse BASIC programs, RetrieVe, or UniData/UniVerse SQL. For UniVerse running on a Linux platform, previously you had to purchase an ODBC driver to work with the EDA solution. Now, Microsoft provides you with ODBC Driver 17 for SQL Server on all Linux platforms. It is free and easy to install and use. UniVerse supports it starting with UV 11.3.1.6018 or later. In this blog, you will learn how to work with the UniVerse EDA solution with Microsoft ODBC Driver 17 for SQL Server on Linux. I’ll cover the sample steps that will convert the UniVerse CUSTOMER file data into SQL Server tables. Note You must order an additional UniVerse EDA package license to work on this solution. You can verify the EDA license information using the “uvregen -z” command. R

Michael Rajkowski April 12, 2017 In part one of the series “Python for the Rocket MultiValue Developer – Part 1 of 3 – Introduction” we discussed the architecture of the Python / MultiValue solution including the fact that the MultiValue and Python code both run in the same process. In this section, you’ll learn how Python interacts with the MultiValue Application Platform, through the use of the u2py module. THE U2PY MODULE The u2py module for Python allows developers to interact with the MultiValue Application Platform in the following ways: run U2 ECL/TCL commands ** read/write U2 files ** handle U2 dynamic arrays manage U2 SELECT lists call U2BASIC catalogued subroutines control U2 transactions ** Introduced in this article GETTING STARTED WITH THE U2PY MODULE The installation of Rocket UniData and Rocket UniVerse includes Python (version 3.4.1). The initial install of Python sets up the needed “.pth” file to point to the u2py module. The u2py.py module provides the interaction

Emma Breslin April 30, 2024 The Rocket MV team is pleased to announce the release of Rocket UniData8.3.2 and Rocket MultiValue Performance Experience (MVX: Performance) 1.10. UniData 8.3.2 is the first UniData release certified with the Rocket MultiValue Performance Experience (MVX: Performance) 1.10, which is available for our customers on maintenance. MVX: Performance monitors the performance of your UniData server and provides DBAs or developers with a better way to track down issues. It determines the root cause of issues, including the server, the operating system, the hardware, or a combination. DBAs can easily receive alerts when over 40 performance monitoring events occur, so constant monitoring is not required. In addition, UniData 8.3.2 and MVX: Performance 1.10 provide you with an enhanced replication experience, bolstering High Availability and Disaster Recovery (HA/DR) capabilities. UniData 8.3.2 extends the security features introduced in UniData 8.3.1, which included

Paul Chang September 18, 2019 Overview External Database Access (EDA) enables you to convert data stored in a Rocket UniVerse or UniData database to a first normal form (1NF) database, such as SQL Server, Oracle and DB2 Server. You can then access that data using existing UniVerseBASIC programs, RetrieVe, or UniData/UniVerse SQL. UniVerse 12.1.1 supports a new EDA solution against MySQL Server. In this blog, you will learn how to work with the UniVerse EDA solution on Windows or Linux against MySQL server 5.6. I will provide sample steps to install & configure the setting to connect to MySQL Server 5.6.Note: You must order an additional UniVerse EDA package license to work on this solution. You can verify the EDA license information using the “uvregen -z” command. Requirements   Version UniVerse 12.1.1 or later UniVerse EDA license Yes EDA Schema Manager 4.34.0   (U2 DB Tools – 4.4.0)   Database Version MySQL Server 5.6 or higher MySQL Server Environment with

Jonathan Smith February 6, 2019 Part 1 of 3 This blog post offers best practices related to implementing and using Replication, as part of a High Availability/Disaster Recovery (HA/DR) strategy. In Part 1, I’ll focus on preparation. I make no apology for this: U2 Replication is NOT an administration free option. In the event of a failure, your organization will absolutely depend on Replication. This blog series will help you to: Avoid common pitfalls that can be encountered in U2 Replication Understand the methods and strategies that have worked well for others Understand the tools that are available for monitoring and tuning of replication Preparation HA/DR 101. The first thing to do when setting up your machines within Replication – primary and standby (the most common configuration) is make sure that both of these machines have fixed IP addresses – their IP addresses do not change. Then, setup a high-level name at the DNS level such as ‘live’- to connect to the current primary or

Emma Breslin March 5, 2024 The Rocket MV team is pleased to announce the release of UniData 8.3.1, U2 Common Clients 5.4.1, and MV BASIC for Visual Studio Code (VS Code) 2.4.0 on February 26th, 2024. Rocket® UniData 8.3.1 UniData 8.3.1 HA/DR enhancements and bug fixes help you manage your replication environment more effectively. We’ve added a new script so you can stop and restart the repmanager, eliminating the requirement to restart UniData if the repmanager becomes unresponsive. We’ve enhanced the "invalid log sequence" message to include the actual and expected LSN number, which will assist you when debugging. We’ve added a skip option to the ud_repadmin command to facilitate recovery from stalled subscriber groups. UniData 8.3.1 security upgrades and enhancements help keep your applications and business safe and compliant. By upgrading to OpenSSL v3.0, UniData supports a wide array of protocol levels. OpenSSL 3.0 includes a major architectural change from OpenSSL 1.1 and bring

I am new to Enterprise Server and am currently working on configuring the environment for an upcoming mainframe migration project.  Currently I am looking to set up my native COBOL CICS region to be able to interact with a MS SQL Server database.  I believe that I need to create an XA resource but I am not sure.  Is this the right direction and if so can someone point me to documentation for how to create the resource?  Thanks for the help.------------------------------Bruce CheatwoodBWXTLynchburg VA US------------------------------

As we wrap February, I want to take a moment to thank every one of you who has joined and contributed to this sub-forum. We're steadily growing into a strong community. 🔹 Content Highlights This month, we shared some exciting blog posts to keep you informed and ahead of the curve: Did you Know Rocket® Zena™ Has These Integrations? How to Navigate and Maximize the Features of the Mobile Browser Client What Makes AI Predictive Pulse Secure? Haven't had a chance to check them out? Dive in and let us know your thoughts! 🔹 Growing Together I'm happy to share that we've grown into a community of 26 members! 🔹What's Next? We want to ensure this space continues to serve your needs. What type of content or discussions would you like to see in the Forum? Let us know in the comments! Thank you again for being a part of this journey. We look forward to another month of learning and collaboration! ------------------------------Martyna UleviciuteCustomer Community Managermuleviciute@rock

As another month comes to a close, I'd like to take a moment to express my sincere thanks to everyone who has joined and contributed to this sub-forum. Together, we're building a vibrant and supportive community! 🔹 Highlights from This Month We shared a couple of insightful blog posts to keep you informed and inspired: Mastering Date Manipulation Variables in Rocket® Zeke™ Scheduling What Makes AI Predictive Pulse Secure? If you haven't had the chance to check them out yet, feel free to read and share your thoughts! 🔹 Community Growth I'm excited that we've already grown into a community of 44 members! 🔹 Celebrating Our Top Contributors A special shoutout to this month's most active members: 🏆 @Brian Stahl and @Senthil Kumaran Suiryamoorthy 🔹 Looking Ahead We're always striving to make this space even more valuable for you. What topics or content would you like to see more of in the Forum? Let us know in the comments! Thank you once again for being such an important part of

Paul Chang June 12, 2019 Using multiple unirpcd daemons to balance client requests can have a positive impact on performance. Also, using a different port for a specific application simplifies management. And, if users are on a newer version of UniData or UniVerse, they might want to use a different port specifically for a secure connection. On newer versions of UniDataand UniVerse, multiple Unirpcd Daemons with different port numbers on Microsoft Windows is supported. When you install UniData or UniVerse, the unirpcd daemon uses deaful port # 31438. This allow all U2 clients ti connect to the UniData or UniVerse server without any additional setting. You might want to start two unirpcd daemons with two different ports for shared unirpcd daemon loading. This blog provides details on U2 clients working against the Unirpcd daemon with different port setting., e.g. # 32438. REQUIREMENTS Data Server Verson UniVerse (Windows) 11.3.1.6018 or later Univers (UNIX) 11.3.1.6022, 12.1.1 o

Emma Breslin July 16, 2024 Rocket UniVerse 14.1.1 builds upon functionality implemented in version 11.4.1 and 12.2.1, making it the upgrade and modernization path for all customers on all prior versions. UniVerse 14 ensures business continuity and helps you manage your replication environment effectively with key HA/DR features. Replication is faster and more flexible with Field-Level Updates, since the entire record is no longer transmitted during updates, only the individual field that was modified is replicated - significantly improving performance! Facilitate Replication recovery with the uv_repadmin skip option which allows you to skip an incomplete transaction that has caused replication to stop processing. By using the skip option, administrators keep Replication processing and avoid log build-up and the eventual reset and refresh of Replication due to a stalled group. Facilitate Replication recovery with the enhanced uvreptool. When Replication has stopped processing due to

Safwat Boulos January 24, 2019 We live in a fast-paced world where executives need real-time reports to make business decisions. Thus, users need information at their fingertips to deliver those reports. If your business-critical data lives in a UniDataor UniVerse MultiValue database, External Data Access (EDA) can help. What is EDA? EDA allows users to convert UniData and UniVerse nested relational data to First Normal Form (1NF), where it can reside in a SQL Server, DB2 or Oracle database, making the data easily accessible to standard tools such as Crystal Reports or any of the many open source products. EDA benefits and implementation EDA allows users to seamlessly transform your UniData and Universe nested-relational data to a normalized form where external SQL tools can access your MultiValue application’s data. Since most users are accustomed to SQL, EDA makes them independent, allowing them to manipulate the data and generate the reports of their choice. EDA lifts the burden fr

Jonathan Smith March 13, 2019 UNIDATA HASHED FILES AND OVERFLOW In this first section we are going to discuss the two main types of UniData Hashed File (Static and Dynamic) and we’re going to discuss the two types of overflow that can occur in these files. The objective of file resizing is to minimize overflow as overflow is a performance overhead. 32-BIT V 64-BIT DYNAMIC HASHED FILES 32-Bit A UniDatastatic file or a sub-file of a dynamic file are limited to 2GB in size. Theoretically a UniData dynamic file can grow to 500GB but the internal management of these multiple sub-files requires complicated code and multiple file I/O operations and hence reduces performance of the files. The block-size of the data file is limited to 16K and as data records are now getting larger and larger this also is a performance limitation of the 32Bit model. 64-Bit The 64-Bit data model introduced at UniData 8.1 will resolve these issues so that data files will have virtually no restrictions on file siz

Paul Chang July 18, 2018 External Database Access (EDA) enables you to convert data stored in Rocket UniVerse and Unidata databases to a first normal form (1NF) database, such as Microsoft SQL Server, then access that data using existing UniVerse BASIC programs, RetrieVe, or UniData/UniVerse SQL. For the UniVerse I-type fields, they can be mapped in many ways to SQL Server. This post will expand the mapping section of the External Database Access manual. Some additional mapping for I-type field dictionary items will be supported in UV 11.3.1.6018 or later version. In this post, you will learn how to work with the UniVerse EDA solution with I-type field dictionary items. I will provide you with sample steps for each of the different I-type field conversions against SQL Server. Note You must order an additional UniVerse EDA package license to work on this solution. The EDA license information could be verified using the “uvregen -z” command. REQUIREMENTS Rocket MultiValue product Ver

Hi All,We have a customer who are upgrading their hardware and OS to a Hyper-V environment running Windows 2022.Does anyone have any experience of running Unidata/Windows 2022 in a Hyper-V environment? Any issues we need to be aware of?Any comments/suggestions are much appreciated.Many thanks.Barry GreenCBS Software

HiTrying to do this training, but it says download the sample programs from the Attachments tab. There is no attachments tab, where can I get the file MFETDUSER.zip which contains the code. Thanks

You'll find it here: cs2cobol.rocketsoftware.com If you did a double take at that and are wondering why you might need such a tool, let me explain... Visual COBOL allows you to compile applications directly to .NET bytecode - or even JVM bytecode - opening up a world of possibilities for integrating COBOL with these platforms and other languages. It's not just Java or C# developers who get to enjoy these ecosystems; Visual COBOL developers can tap into their libraries and functionality too. That's where this tool comes in. If you come across a snippet of C# code online and wonder how to express it in COBOL, the C# to COBOL Converter will help bridge the gap. Give it a try! using System; namespace CsharpString { class Test { public static void Main(string [] args) { // create string string str = "C# to COBOL"; Console.WriteLine("string: " + str); // get length of str int length = str.Length; Console.WriteLine("Length: "+ leng

Good Day.I have a 2x Windows 2022 Server that is running in Azure that is Joined to the same Domain that is allocate in the Client office.Universe is loaded on each of the Windows Server 2022 in Azure. All my test is running of the 2 servers. I have a Domain user as well as a Local user.  I am using Dynamic Connect First Test Server 1. use the Domain user via Dynamic ConnectAfter you enter the password until it displays for you which Account you want to login .it take 23 second to pop up. See screenshot below With the local User it takes 1 second to pop up. Then, I move to the second server that is on the same domain, authenticate to the same Domain. Use the same Domain user, Same test via Dynamic Connect.The login there are 2 second to pop up. Did anyone have this issue before? Is the Issue with the Domain or Universe. If you can just point me into the correct directions to resolve this issue Thank you------------------------------Armand SteynSelf RegisteredGermiston ZA--------------

Does C$PDF support concurrent job processing? Does C$PDF support file name control (no user interaction)?------------------------------Ken SchwartzSenior Engineer, DevelopmentSouthware Innovations, IncOpelika US------------------------------

We have several users that are getting kicked out of their Eclipse session with an LBO error message  (Func=DISCONCT complete RC=0 Reason=6010). I cannot find 6010 in the ZMF Messages Guide. Can anyone provide guidance?------------------------------Jim HaworthTechnology EngineerNationwide Mutual Insurance Company------------------------------

Hi, we have recently installed openssl on our OMVS partitions: normally we use RACF as a KeyStore for certificates. Any integration is foreseen / possible to use RACF as a key store, as for SecureZip ? Or the only way is to manage a local KeyStore in the OMVS partition? Thanks

Patch 10.4.03-010 Downloads Product availability Matrix (PAM) Downloads of this patch are available from the Rocket Customer Support Portal. Further explanation can be found here. New Feature(s)Modification dates are re-introduced in the IDE for sub Udo's allowing you to implement better control over what objects you need to re-compile. The compiler sub switches /aft and /bef can be used again accordingly. Notes: * Your export files will change with additional timestamps being exported. * Imports from older Uniface versions that had timestamps will show these again. * Migration actions do not update timestamps. * Only changed objects get an updated timestamp. FixesUNI-41736Discard in read trigger can cause '9033 - proc stack overflow' in 10.4.03UNI-36602When using the result of $random in specific ProcScript calculation it causes the application to crash. UNI-41736  -  Discard in read trigger can cause '9033 - proc stack overflow' in 10.4.03 Solut

you will no be able to run or compile any cobol program in vs code even you have installed the learned cobol extension or other cobol plugging , here is the error message  Micro Focus COBOL Version 7.0 (C) Copyright 1984-2021 Micro Focus or one of its affiliates. (0,0) : error COBCH1889 : License failure: Cannot communicate with licensing daemon.  ------------------------------Marcos RamosSelf RegisteredPanama PA------------------------------

Do you manage complex workflows across different systems? The last thing you want is a fragmented approach to integration.  IBM i systems are known for their reliability and security, but managing schedules and data workflows within them can get complicated-especially when juggling multiple applications. That's where Rocket® Zena comes in! 🚀 It eliminates complexity by integrating directly with IBM i, allowing you to automate and manage batch jobs seamlessly. 🔗 Read the full blog post here What challenges have you faced when managing workflows in IBM i? Let's discuss in the comments! ------------------------------Olivia SultanovSolution Marketing ManagerRocket Forum Shared Account------------------------------

Trying to connect odbc driver from Unisys from visual cobol, getting the error "x114 item beyond access item beyond bounds of memory (signal 11)".  I have crated a system dsn  and trying to connect from cobol program like :  EXEC SQL               CONNECT TO :svr USER :usr-passEND-EXEC I also tried to use the below format : STRING 'DRIVER={Unisys MCP ODBC Driver(x86)};'            'SERVER=xx.x.xx;'            'PORT=2012;'            'DATABASE=test;'            'USER=xxxx;'            'PASSWORD=xxxxx;' INTO BUFFER.     EXEC SQL       CONNECT TO :BUFFER     END-EXEC. The above is not recognizing the system DSN created and it is giving error  "The data source not found and no default driver specified" but while testing on the "ODBC data Source application", the connection is working fine.   Could some one help with what is needed to support unisys data source.    ------------------------------Kayal vizhiRocket Forum Shared Account------------------------------