Stored Procedure Reference

Feedback

Copyright © 2013 iWay Software

This documentation provides information about programs or procedures, called stored procedures, that reside on a server and are called by connector applications. Stored procedures allow users to build on existing applications to create new client/server applications for the desktop environment. This documentation is intended for the API Programmer, the Dialogue Manager Programmer, and others who develop and maintain client/server applications that call stored procedures.

For up-to-the-minute information, please refer to the release notes.

How This Manual Is Organized

This manual includes the following chapters:

Chapter/Appendix

Contents

1

Introducing Stored Procedures

Describes the types of stored procedures, how they are called, and their execution order. Explains why stored procedures are used.

2

Calling a Program as a Stored Procedure

Describes ways to call a compiled program using the API function call EDARPC, and using the commands CALLPGM or EXEC in a Dialogue Manager procedure. Addresses the use of parameters.

3

Calling a JAVA Class as a Stored Procedure

Describes ways to call a JAVA class using the CALLJAVA command or the EX command.

4

Writing a 3GL Compiled Stored Procedure Program

Describes the requirements for writing a program to be called by EDARPC, or by CALLPGM in a Dialogue Manager procedure. Addresses the control block used for communication between the server and the program; storage of program values; error handling; and the command CREATE TABLE, which a program issues to describe the answer set it is returning.

5

Writing a Dialogue Manager Procedure

Describes the features of the Dialogue Manager language, including the syntax and use of Dialogue Manager commands and how they are processed by the server.

6

Platform-Specific Commands and Features

Describes the syntax and use of platform-specific commands that can be included in a Dialogue Manager procedure, such as DYNAM in MVS.

A

Dialogue Manager Quick Reference

Includes all Dialogue Manager commands, with their syntax, in alphabetical order for easy reference.

B

GENCPGM Usage

Describes how to use the script that has been created for UNIX, Windows NT/2000, and OpenVMS to assist in simple compilations.

Documentation Conventions

The following table describes the documentation conventions that are used in this manual.

Convention

Description

THIS TYPEFACE

or

this typeface

Denotes syntax that you must enter exactly as shown.

this typeface

Represents a placeholder (or variable) in syntax for a value that you or the system must supply.

underscore

Indicates a default setting.

this typeface

Represents a placeholder (or variable), a cross-reference, or an important term. It may also indicate a button, menu item, or dialog box option that you can click or select.

Key + Key

Indicates keys that you must press simultaneously.

{  }

Indicates two or three choices. Type one of them, not the braces.

[  ]

Indicates a group of optional parameters. None are required, but you may select one of them. Type only the parameter in the brackets, not the brackets.

|

Separates mutually exclusive choices in syntax. Type one of them, not the symbol.

...

Indicates that you can enter a parameter multiple times. Type only the parameter, not the ellipsis (...).

.

.

.

Indicates that there are (or could be) intervening or additional commands.

Related Publications

Visit our Technical Documentation Library at http://documentation.informationbuilders.com. You can also contact the Publications Order Department at (800) 969-4636.

Customer Support

Do you have any questions about this product?

Join the Focal Point community. Focal Point is our online developer center and more than a message board. It is an interactive network of more than 3,000 developers from almost every profession and industry, collaborating on solutions and sharing tips and techniques. Access Focal Point at http://forums.informationbuilders.com/eve/forums.

You can also access support services electronically, 24 hours a day, with InfoResponse Online. InfoResponse Online is accessible through our website, http://www.informationbuilders.com. It connects you to the tracking system and known-problem database at the Information Builders support center. Registered users can open, update, and view the status of cases in the tracking system and read descriptions of reported software issues. New users can register immediately for this service. The technical support section of www.informationbuilders.com also provides usage techniques, diagnostic tips, and answers to frequently asked questions.

Call Information Builders Customer Support Services (CSS) at (800) 736-6130 or (212) 736-6130. Customer Support Consultants are available Monday through Friday between 8:00 a.m. and 8:00 p.m. EST to address all your questions. Information Builders consultants can also give you general guidance regarding product capabilities. Please be ready to provide your six-digit site code number (xxxx.xx) when you call.

To learn about the full range of available support services, ask your Information Builders representative about InfoResponse Online, or call (800) 969-INFO.

Information You Should Have

To help our consultants answer your questions most effectively, be ready to provide the following information when you call:

User Feedback

In an effort to produce effective documentation, the Technical Content Management staff welcomes your opinions regarding this document. Please use the Reader Comments form at the end of this document to communicate your feedback to us or to suggest changes that will support improvements to our documentation. You can also contact us through our website, http://documentation.informationbuilders.com/connections.asp.

Thank you, in advance, for your comments.

iWay Software Training and Professional Services

Interested in training? Our Education Department offers a wide variety of training courses for iWay Software and other Information Builders products.

For information on course descriptions, locations, and dates, or to register for classes, visit our website (http://education.informationbuilders.com) or call (800) 969-INFO to speak to an Education Representative.

Interested in technical assistance for your implementation? Our Professional Services department provides expert design, systems architecture, implementation, and project management services for all your business integration projects. For information, visit our website (http://www.informationbuilders.com/support).