Exercise 1: Creating a Simple User-Defined Routine, continued

DataBlade Developers Kit Tutorial

InfoShelf Home

Tutorial Start

Print Tutorial

List of Exercises

Exercise 1: Creating a Simple User-Defined Routine, continued

2

Use BladeSmith to create the AddIntegers() function.

Choose Edit Insert Routine and enter the following information in the New Routine wizard.


Routine Property	AddIntegers Value
Routine Name (SQL)	AddIntegers
Return type	integer
Statement Local Variable	No
Arguments	Name: Int1 Type: integer Default: none Name: Int2 Type: integer Default: none
Language	C
Options for how the database server calls this routine (page 5)	Only the Routine does not accept NULL arguments check box should be checked; uncheck the Routine may return inconsistent check box.
Routine Name (C)	AddInts
Shared object path	Leave as default
Behavior of routines	Routine is well-behaved
Special stack requirements	None
Cost	0
Related routines	None
Grant execute privileges	Grant execute privileges

Click Finish. The AddIntegers() function appears in the User Defined Objects folder.

Choose Project Save to save the changes to your DataBlade module.

InfoShelf Home

Tutorial Start

Print Tutorial

Copyright © 1998, Informix Software, Inc. All rights reserved.