Informix

INFORMIX-4GL

Quick Syntax

Version 6.0 April 1994 Part No. 000-7609

2

Published by INFORMIX® Press

Informix Software, Inc. 4100 Bohannon Drive Menlo Park, CA 94025

The following are worldwide trademarks of Informix Software, Inc., or its subsidiaries, registered in the United States of America as indicated by an “®,” and in numerous other countries worldwide:
INFORMIX® andC-ISAM®.

The following are worldwide trademarks of the indicated owners or their subsidiaries, registered in the United States of America as indicated by an “®,” and in numerous other countries worldwide: X/OpenCompany Ltd.: UNIX®; X/Open® Adobe Systems Incorporated: Post Script® Some of the products or services mentioned in this document are provided by companies other than Informix. Theseproducts or services are identified by the trademark or servicemark of the appropriate company. If you have a question about one of those products or services, please call the company in question directly. ACKNOWLEDGMENTS The following people contributed to this version of INFORMIX-4GL Quick Syntax: Documentation Team: Technical Contributors: Adam Barnett, Kaye Bonney, Lisa Braz, Tom Houston, Liz Knittel,Jerry Pope Jonathan Leffler, Sally Cox

Copyright © 1981-1994 by Informix Software, Inc. All rights reserved. No part of this work covered by the copyright hereon may be reproduced or used in any form or by any means—graphic, electronic, or mechanical, including photocopying, recording, taping, or information storage and retrieval systems— without permission of the publisher. RESTRICTED RIGHTSLEGEND Software and accompanying materials acquired with United States Federal Government funds or intended for use within or for any United States federal agency are provided with “Restricted Rights” as defined in DFARS 252.227-7013(c)(1)(ii) or FAR 52.227-19.

Table of Contents

INFORMIX-4GL Quick Syntax
Introduction 5
Syntax Conventions 6

Basics

9

Data Types 10 4GL ArithmeticOperators 10 Boolean Operators 10 4GL Relational Operators 10 Global Constants and Variables 11 Built-In Functions 11 Operators 11 Library Functions 12 Display Attributes 15 Command-Line Syntax 16

4GL Statements 19
Types of SQL Statements 20 Other Types of 4GL Statements 4GL Statement Segments 37 21

4GL Forms 47
Form Specification Syntax 48 Attributes 50

Reports

55

Report SpecificationSyntax 56 Report Execution Statements 59

SQL Statements 61
SQL Segments 91 Stored Procedure Language Statements 105

4

SQLCA Record

113 117
126

Interactive Debugger Commands

Command-Line Syntax 119 4GL Interactive Debugger Command Segments

Environment Variables

129 133

Default Key Assignments

Introduction

6

Syntax Conventions

This Guide presents a quickreference to the material listed in the following table. For a full discussion of each topic, refer to the corresponding documentation.
Topic Data types Built-in functions and operators 4GL statements SQL statements 4.1 servers: 6.0 servers: Reference Documentation INFORMIX-4GL Reference INFORMIX-4GL Reference INFORMIX-4GL Reference Informix Guide to SQL: Reference Informix Guide to SQL: Syntax,Version 6.0 Section Chapter3 (DEFINE) Chapter 4 Chapter 3 Chapter 6 Chapter 1 Chapter 2 Chapter 5 Chapter 6 Chapter 2 Chapter 9 Appendix D

Stored Procedure Language (SPL) 6.0 servers: Informix Guide to SQL: Syntax, Version 6.0 4GL forms Reports
SQLCA record structure

INFORMIX-4GL Reference INFORMIX-4GL Reference INFORMIX-4GL Reference Guide to the INFORMIX-4GL Interactive DebuggerINFORMIX-4GL Reference

NewEra Debugger commands Environment variables

This Guide shows syntax that must be prepared before you can include it in a 4GL program. You must prepare any SQL statement introduced later than the 4.1 server release. These statements are indicated in this manual by the following icon:
6.0 SE

To use these statements, such as CREATE TRIGGER, you must: 1. Store the SQL...