List of Exercises
Tutorial Exercise 4
Creating Row Data Types
This exercise demonstrates creating
row data types and user-defined routines that operate on them.
The RowCircle DataBlade module creates two new data types, rciPoint and rciCircle, and two new functions, rciDistance() and rciContains().
The RowCircle DataBlade module enables you to:
- store circles or points in a single column of a database table.
- calculate the distance between two points.
- calculate whether a circle contains a point.
The following diagram illustrates the type of data RowCircle data types contain.
Tutorial Steps
This exercise consists of 13 steps. It takes approximately one hour to complete.
Start BladeSmith from the Informix program group and choose Project
New.
Enter the following information into the New Project wizard.
|
Project Property
|
Value
|
|---|
|
DataBlade module name
|
RowCircle
|
|
Object prefix
|
rci
|
|
Description locale
|
en_us.1252
|
|
Server compatibilty
|
9.13 or 9.14
|
|
Project version number (Major.Minor)
|
1.0
|
|
Project description
|
This DataBlade module supports the rciPoint and rciCircle row types.
|
|
Vendor unique ID (optional)
|
Your company's name
|
|
Company information
|
Your company's name, copyright, and contact information
|
Click Finish.
Choose Project Save; create a new directory called RowCircle in any convenient place on your hard drive and save your project in this directory as a file called RowCircle.ibs.
Copyright © 1998, Informix Software, Inc. All rights
reserved.
