Skip to content. | Skip to navigation

Sections
Personal tools
You are here: Home Accelerate Articles

Summary of Articles

 

U2 SELECT Verb List Extension

Peter M. Newby (pnewby@epicor.com), Principal Software Engineer, Epicor Software

This article provides a general solution to the problem of record selection based on a large list of non-primary-key values. It is a step-by-step guide to building a new verb which selects records based on a match between dictionary values and standard Rocket U2 UniData® SAVE.LIST and SELECT buffer lists. For those who like to build their own tools, it offers an interesting project. For those who prefer to use tools others have built, the completed verb source code is available as a download.

Read this article arrow_right.gif

Use External Database Access with U2

Yinghong Fei (yfei@rs.com), Software Engineer, Rocket Software

External Database Access (EDA) has been created to allow U2 users the flexibility of storing some or all of their data in external relational database management systems (RDBMS). While EDA documentation describes all the EDA features and their usages, the purpose of this article is to explain how you can use EDA features to satisfy various requirements and to discuss some common issues that arise when converting and using EDA files.

Read this article arrow_right.gif

Validate Data Types in U2 using XML Schema 

Michael Rajkowski (mrajkowski@rs.com), U2 Senior Technical Support Engineer, Rocket Software

Rocket U2 ( Unidata and UniVerse ) stores all of its data without any type validation. Thus the same field can contain an integer, a string, or even an internal date structure. While this may be useful to the application developer, it can cause problems when integrating the data from your U2 environment to an external environment. In this article, validate the data against a schema and prevent invalid data with update triggers.

Read this article arrow_right.gif

UniData Recoverable File System (RFS) 

Wally Terhune ( wterhune@rs.com), U2 Support Architect, Rocket Software

Database and system administrators who are responsible for a UniData system that has the Recoverable File System (RFS) feature enabled will find this article most helpful. All RFS status and error messages are recorded in the $UDTBIN/sm.log file. You will find examples to help you find and decipher the messages to determine the appropriate actions needed to keep your system running smoothly.

Read this article arrow_right.gif

Understanding Rocket U2 XML Features

LeRoy Dreyfuss ( u2support@rs.com)

This article reviews the XML capabilities within Rocket U2 UniData® and UniVerse®. Learn the various functions within the databases to develop robust applications that can communicate with any system using XML. Explore the U2 XDOM and XMAP APIs and how to produce XML documents from the database query engines. Examples are included.

Read this article arrow_right.gif

Rocket U2: The Big Picture

Jackie Burhans ( jburhans@rs.com), Director of U2 Partner Enablement, Rocket Software

Gain a basic understanding of the Rocket U2 product line, and gather information about the extended relational data model, architecture, benefits, and associated tools products.

Read this article arrow_right.gif

Zeroing in on UniData Problems

Wally Terhune (wterhune@rs.com), U2 Support Architect, Rocket Software

This article is written to assist with the problem determination process for someone administering or supporting UniData databases. If you're faced with a puzzling problem, here are some questions to ask in order to zero in on the problem, and actions to take to solve it.

Read this article arrow_right.gif


UniVerse

Use External Database Access with U2

Yinghong Fei ( yfei@rs.com), Software Engineer, Rocket Software

External Database Access (EDA) has been created to allow U2 users the flexibility of storing some or all of their data in external relational database management systems (RDBMS). While EDA documentation describes all the EDA features and their usages, the purpose of this article is to explain how you can use EDA features to satisfy various requirements and to discuss some common issues that arise when converting and using EDA files.

Read this article arrow_right.gif

Validate Data Types in U2 using XML Schema

Michael Rajkowski (mrajkowski@rs.com), U2 Senior Technical Support Engineer, Rocket Software

Rocket U2 ( Unidata and UniVerse ) stores all of its data without any type validation. Thus the same field can contain an integer, a string, or even an internal date structure. While this may be useful to the application developer, it can cause problems when integrating the data from your U2 environment to an external environment. In this article, validate the data against a schema and prevent invalid data with update triggers.

Read this article arrow_right.gif

Understanding Rocket U2 XML Features

LeRoy Dreyfuss ( u2support@rs.com)

This article reviews the XML capabilities within Rocket Software® UniData® and Rocket Software UniVerse®. Learn the various functions within the databases to develop robust applications that can communicate with any system using XML. Explore the U2 XDOM and XMAP APIs and how to produce XML documents from the database query engines. Examples are included.

Read this article arrow_right.gif

Rocket U2: The Big Picture

Jackie Burhans ( jburhans@rs.com), Director of U2 Product Strategy, Rocket Software

Gain a basic understanding of the Rocket U2 product line, and gather information about the extended relational data model, architecture, benefits, and associated tools products.

Read this article arrow_right.gif


SystemBuilder

How to Include an ActiveX Control within an SB+ Input Screen

Kevin Drury ( kdrury@rs.com), SB+ Developer, Rocket Software
Pavel Smelianski ( psmelianski@rs.com), SBClient Expert, Rocket Software

ActiveX technology provides a rich set of self-contained controls that can enhance the U2 SB+ user experience. This article takes you through two examples. In the first example, you see how to include a calendar control within an input screen. In the second example, see how to include an HTML object within an input screen.

Read this article arrow_right.gif

Understanding the SB+ Security API

Brian Kupzyk( bkupzyk@rs.com), Support Engineer, Rocket Software

In the past, accessing SB+ or SB/XA for UniData and UniVerse security from outside of SB security screens was difficult. But now, you can use a new function, SH.SEC.API, to talk to SB+ or SB/XA security using subroutine calls when outside of the SB security screens. Beginning with SB+ 5.4.0 and SB/XA 6.0.0, it makes it significantly easier for the system administrator to maintain SB security. This article teaches you how to implement this API and includes detailed programming examples.

Read this article arrow_right.gif

How to Deploy SB+ Password Validation

Ehab AbuShmais ( eabushmais@rs.com), Global Technical Support Manager,  Rocket Software

IT security is a vital component of business success. Guessing passwords is one of the most common attack methods that a system experiences. Therefore, controlling, managing, and monitoring your application password-restriction policy is essential. This article provides you with a step-by-step password validation deployment method for SystemBuilder™ security.

Read this article arrow_right.gif

Enable Multi-language Support in SB+

Ehab AbuShmais ( eabushmais@rs.com), Global Technical Support Manager,  Rocket Software

The SB+™ Server is an application development tool within the U2 database environment, and comprises the default development tools, runtime support libraries, and server-side execution of client/server functions. Use the new functionality in SB+ to build an application that functions in multiple languages using multiple definitions.

Read this article arrow_right.gif


U2 Web Development Environment

PHP and .Net Web Development for U2 using Web DE / RedBack Objects

Ray Else (relse@rs.com), Software Developer, Rocket Software

Rocket U2 Web DE, U2 Web Development Environment (previously called RedBack®), is a Web framework for accessing UniVerse® and UniData® databases. In this article, examine the history and essential framework of Web DE, and learn how PHP and .NET can reference Web DE RedBack Objects (RBOs) to access U2 data stores in a similar way that ASP and Java™ technology can use them.

Read this article arrow_right.gif

Best Practices and Performance Considerations using RedBack Objects

Ray Else (relse@rs.com), Software Developer, Rocket Software

Learn the best practices of RedBack® Object planning, creation, and use for an effective Web site. Poorly planned use of RedBack Objects could mean a slow-performing Web site (and an unnecessary load on your database server), whereas the well-planned use of RedBack Objects can mean a fast, productive site.

Read this article arrow_right.gif

Connect WebSphere Voice Server SDK to U2 using RedBack JavaBeans

Louis Tur ( ltur@rs.com), U2 Sales Engineer, Rocket Software
Learn how to retrieve data from a U2 database management system using the voice technology of WebSphere® Voice Server SDK.

Read this article arrow_right.gif


SOA

U2 and Service Oriented Architecture (SOA)

Michael Rajkowski ( mrajkowski@rs.com), Software Engineer - U2 Client Support, Rocket Software
Service oriented architecture is an application framework that takes everyday business applications and breaks them down into individual business functions and processes, called services. SOA lets you build, deploy, and integrate these services independent of applications and the computing platforms on which they run, making business processes more flexible. In this article, learn how Rocket Software® UniData® and UniVerse® (U2) technology relates to SOA.

Read this article arrow_right.gif

U2 SOAP API Client

Nik Kesic (nkesic@rs.com), Software Engineer, Rocket Software

The Rocket Software® UniData® and UniVerse® databases (U2) offer many APIs that can leverage your application investment from a closed environment to a fully integrated open environment (Internet). This article explores some of the U2 Extended BASIC APIs, namely SOAP, DOM, XPath, XMLDB, XMAP, and the XML DB mapping tool.

Read this article arrow_right.gif


Security

Secure U2 Web Services

Reynal Cocaign (rcocaign@rs.com), Senior Software Engineer, Rocket Software
Nik Kesic ( nkesic@rs.com), Senior Software Engineer, Rocket Software

With the increasing acceptance and usage of SOA driving business information in the global economy, it has become critical to provide protection, confidentiality, and integrity of sensitive information. The U2 Web Services Developer allows you to publish business functions as Web services and make them available to outside protected network hierarchies. This article takes you on a journey in the world of U2 information security for Information on Demand.

Read this article arrow_right.gif

U2 Security in Motion

Nik Kesic ( nkesic@rs.com), Senior Software Engineer, Rocket Software

Michael Rajkowski (mrajkowski@rs.com), Technical Support Engineer, U2 Client Support, Rocket Software

Good data governance practices and regulatory compliance requires securing data while in motion to prevent eavesdroppers from viewing sensitive information. Rocket U2 UniData and UniVerse (U2) provide the tools that conform to open encryption and SSL standards that enable protection of data stream and the information inside it. The U2 tools, in conjunction with other popular developer framework tools, help create a solution ready for the global economy. Explore the four worlds of Information Security using BASIC, C#, Java™ programming, and scripting languages to secure the transmission of information.

Read this article arrow_right.gif


U2 Encryption in an Open Technology World

Nik Kesic ( nkesic@rs.com), Senior Software Engineer, Rocket Software

If you have valuable, sensitive, or confidential data, and the data can be accessed or seen by unauthorized people, then data encryption is a must. The extended BASIC APIs of Rocket Software® UniData® and UniVerse® (U2) perform symmetric encryption operations on data using various available ciphers. The heart of the U2 encryption function is the OpenSSL library. Walk through the four worlds of encryption covering C#, Java™, U2 BASIC, and OpenSSL shell scripting and see that encryption of data produced is interchangeable amongst them.

Read this article arrow_right.gif

Data Encryption in UniData and UniVerse

Bill Winter ( bwinter@rs.com), U2 Sales Engineer, Rocket Software

Recent government regulations and market demand have increased requirements for protecting data resources. Data encryption is an important tool to help application developers meet the need for greater security. This article describes the encryption options available in Rocket Software UniData® and UniVerse® database products and shows how they can be used to add data encryption into a U2 application.

Read this article arrow_right.gif


.NET

UniObjects for .NET Compact Framework

Nik Kesic(nkesic@rs.com), Software Engineer, Rocket Software
Kendrew Peacey ( kpeacey@rs.com), Architect and developer of SB/XA, Rocket Software

Rapidly evolving client needs are driving advances in information technology that are making the world seem smaller and flatter. One of the basic underlying requirements of these needs is access to information anywhere, on any device, at any time. The U2 UniObjects for .NET Compact Framework (UO.NETCF) library makes this kind of access possible. This article provides an example of how to take an existing PC-based application that communicates with a U2 database, and use it as the basis for developing a mobile application using UO.NETCF.

Read this article arrow_right.gif

Develop a sample application using LINQ programming and the ADO.NET Entity Framework with IBM DB2, IDS, and U2 servers

Rajan Kumar ( rkumar@rs.com), Software Developer, Rocket Software
Brent Gross ( gross@ca.ibm.com), Software Developer, IBM

The IBM Data Server Provider for .NET enables application developers to take advantage of the Microsoft® Entity Framework and LINQ. You can easily develop data access .NET applications using one of the IBM data servers (DB2®, Informix® Dynamic Server) or U2, the Microsoft ADO.NET Entity Framework, and LINQ. This article shows you how to get started using the Entity Framework with one of the data servers, walking you step-by-step through the process of creating your own application.

Read this article arrow_right.gif

Access U2 data server from your .NET applications, Part 1: Overview of IBM Data Server Provider for .NET and IBM Database Add-ins for Visual Studio for UniVerse and UniData

Rajan Kumar ( rkumar@rs.com), Software Developer, Rocket Software
Brent Gross ( gross@ca.ibm.com), Software Developer, IBM

IBM® Data Server Provider for .NET and IBM Database Add-ins for Visual Studio support multiple IBM data servers, including DB2®, Informix® Dynamic Server, and the U2 data servers, UniVerse®, and UniData®. This article is the first of a series of articles and tutorials that explain the functionality of the .NET Provider and the Add-ins for the U2 data servers. As a U2 developer, you'll learn to build Windows®, ASP.NET Web, Web services, AJAX, reporting, and Windows Presentation Foundation (WPF) and Extensible Application Markup Language (XAML) applications with little or no code. You'll use standard interfaces such as ADO.NET against U2 data servers.

Read this article arrow_right.gif


PHP

U2 PDO Driver, Part 1: Write a PHP Data Objects Driver for U2

Double Xia ( sxia@rs.com), Software Engineer, Rocket Software

The PHP Data Objects (PDO) extension provides a lightweight, convenient means for accessing databases in PHP. However, you must use a database-specific PDO driver to access a database server. Currently there is no PDO driver for the Rocket Software® U2 data servers, UniData® and UniVerse®. In this article, you'll learn how to write a PDO driver for U2 using the U2 native interface, InterCall. With this PDO driver, U2 users can develop PHP applications that access U2 data quickly and easily.

Read this article arrow_right.gif

U2 PDO Driver, Part 2: Write PHP Applications to Access U2 data

Double Xia ( sxia@rs.com), Software Engineer, Rocket Software

PHP is one of the most popular languages for Web applications, and now you can use it to access your U2 data. In part 1 of this series, you learned how to create a PHP Data Objects driver for U2. Now, learn how to put the driver you've created to use in a PHP application.

Read this article arrow_right.gif

Document Actions