- May 20, 2019
AUTHOR DETAILS
-
Paul Chang8 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.
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 time […]
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 […]
UniVerse External Database Access (EDA) with I-type field dictionary items against SQL Server
Overview 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 […]
UniVerse External Database Access (EDA) with Microsoft ODBC Driver 17 for Linux
Overview 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 […]
Our latest tweets
Rocket's George Smyth tells us how hosting #blockchain on #mainframes allows businesses to take advantage of their computing power, #security, #cryptography & reliability. buff.ly/2YvguTr pic.twitter.com/Q6ge…
Recent Comments