- July 24, 2021
AUTHOR DETAILS
-
Paul Chang10 Posts
Paul Chang is a Principal Technical Support Engineer at Rocket Software. He is responsible for supporting all U2 common middleware client products, Java products and .NET clients. He has 35 years of experience in computing and holds a master’s degree in Computer Science with an emphasis on Relational Database Design.
External Database Access (EDA) works on Rocket ® UniVerse 12.1.1 against MySQL Server 5.6 or later
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 UniVerse BASIC programs, RetrieVe, or UniData/UniVerse SQL. UniVerse 12.1.1 supports a new EDA solution […]
Working with U2 Clients against U2 unirpc Daemon using a different port
Overview 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 […]
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 […]
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 […]
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 […]
Our latest tweets
Do you need to share the impact of #Db2 schema changes with your development team? Check out this free Z Trial to see how easy it can be. It’s completely free and accessible with a few clicks: bit.ly/AF_zTrial #IBMZ #DBA #Db212 #Db2z pic.twitter.com/l3bN…
Recent Comments