AUTHOR DETAILS

  • Avatar

    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.

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

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

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

Tutorials UniData Universe

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

Technology Tutorials Universe

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