Feedback |
This manual provides information on the iWay Server Structured Query Language (SQL). It is primarily intended for those persons concerned with programming applications that use the iWay Server SQL.
iWay is a family of integrated middleware products which, when combined, insulate both application end-users and developers from the complexity and incompatibilities of proprietary computing environments.
This manual includes the following chapters:
Chapter/Appendix |
Contents |
|
1 |
Provides an overview of the Server SQL. |
|
2 |
Explains how the server handles SQL requests, using either SQL Passthru or SQL Translation. |
|
3 |
Describes the language elements of SQL, including characters, tokens, qualifiers and identifiers. |
|
4 |
Provides a summary of supported and unsupported SQL statements and expected results from queries. |
|
5 |
Describes how to build tables and views. |
|
6 |
Describes how to use PREPARE to submit parameterized SQL requests for subsequent execution using EXECUTE. |
|
A |
Lists SQL keywords. |
|
B |
Provides a summary of Backus Naur Form notation. |
The following conventions apply throughout this manual:
Convention |
Description |
THIS TYPEFACE or |
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 you can click or select. |
this typeface |
Highlights a file name or command. |
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 points (...). |
. |
Indicates that there are (or could be) intervening or additional commands. |
Visit our World Wide Web site, http://www.iwaysoftware.com, to view a current listing of our publications and to place an order. You can also contact the Publications Order Department at (800) 969-4636.
Do you have questions about iWay Server Structured Query Language (SQL)?
Call Information Builders Customer Support Service (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 iWay Server Structured Query Language (SQL) questions. Information Builders consultants can also give you general guidance regarding product capabilities and documentation. Please be ready to provide your six-digit site code number (xxxx.xx) when you call.
You can also access support services electronically, 24 hours a day, with InfoResponse Online. InfoResponse Online is accessible through our World Wide Web site, 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.
To learn about the full range of available support services, ask your Information Builders representative about InfoResponse Online, or call (800) 969-INFO.
To help our consultants answer your questions most effectively, be ready to provide the following information when you call:
In an effort to produce effective documentation, the Documentation Services staff welcomes any opinion you can offer regarding this manual. Please use the Reader Comments form at the end of this manual to relay suggestions for improving the publication or to alert us to corrections. You can also use the Documentation Feedback form on our Web site, http://www.informationbuilders.com/bookstore/derf.html.
Thank you, in advance, for your comments.
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 World Wide Web site (http://www.iwaysoftware.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 World Wide Web site (http://www.iwaysoftware.com).