Latest Posts

Technology

EDA tables cannot be joined with two different collations against SQL Server: A Solution

Overview External Database Access (EDA) enables you to convert data stored in the Rocket U2 database to a 1NFdatabase, such as Microsoft SQL Server, then access that data using existing UniVerse BASIC programs, RetrieVe, or UniData/UniVerse SQL. There are a number of reasons to join EDA tables. When combining rows from multiple tables in one […]

Events

Please vote for Rocket Software: Best MultiValue Database

Rocket Software is extremely grateful for your continued support of our MultiValue products, including UniVerse, UniData and D3. These tools help thousands of organizations around the world solve critical business and technical issues, and we come to work every day to make them even better. Each year, awards are given by the readers of Database […]

D3

❤️ Love your data? Fall in love with your backups. ❤️

Data is the lifeblood of your business. What happens if you lost access to it, or even worse, lost your data altogether? Would your business survive? The stories we tell here are true. We have changed the names to protect the innocent. You may already know Phil and Phyllis. They work for Acme Corp. with […]

Technology

New Replication Scripts for Microsoft Windows

Starting at 1.6.3 on Microsoft Windows the console program has been dropped and rewritten completely in Windows Power Shell U2 Replication is a very powerful, very configurable but very complex part of both UniData and UniVerse. Many customers have historically become very adept at deploying there U2 Applications into environments where the people responsible for […]

Technology

New TIMESTAMP data type is supported on UniVerse 11.3.1.6024 and soon on 12.1.1 (Phase 1)

Overview Timestamp data, while very common and important, is not easy to store and use at the current UniVerse versions. You must convert it to two fields in UniVerse file and use the I-Type field to combine two fields back to the original timestamp data. Now you can save timestamp data to Unix Epoch time […]

Events

Rocket.Build Denver/Irvine

Innovation, a competitive spirit, and energy were abuzz in the Rocket Denver office as MultiValue teams prepared for the Rocket.Build local Denver/Irvine event which focused mainly on MultiValue projects. Rocket.Build is a 2-day intense brainstorming and development time where teams come together to work on projects they think would be beneficial to our customers. At […]

Technology

How the Cloud can secure proven, business-critical applications running on older operating systems & hardware

Application lifecycle management can get pretty tricky when your proven, business-critical application is doing its job and the cost/value of  a hardware/operating system upgrade doesn’t make sense. These applications are typically a bit cumbersome to maintain, in regard to security and compliance, especially as they age. We will look at this situation from two different […]

Technology

Understanding UniData Hashed and Dynamic Files with RESIZE and memresize

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 […]

Technology

Rocket UniData and UniVerse Replication best practices: REPLOGGER

Part 3 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 3, I’ll focus on Replogger. REPLOGGER REPLOGGER is a BASIC program that runs on the server side that allows you to monitor replication performance. The information it collects […]

Technology

Using UniData 8.2.1 with v6.0 schema files: Overview

If you use the U2 ODBC and/or JDBC client with UniData v8.2.1, you need to ensure that all accounts use schema v6.0 files. If they do not, the applications will not work with your UniData account. This blog post shows you how to create new UniData accounts with schema v6.0 files, delete corrupt files and […]

Technology

Rocket UniData and UniVerse Replication best practices: monitoring

Part 2 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 2, I’ll focus on monitoring. Monitoring As a best practice, everyone should use the Exception Action Script to keep Replication in sync even during unplanned network interruptions, heartbeat […]

Technology

Rocket UniData and UniVerse Replication best practices: preparation

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 […]