Manual

jBASE Query Language

Programmers Reference Manuals

jBASE 4.1

JBASE Query Language

jQL

Copyright
Copyright (c) 2002 TEMENOS HOLDINGS NV All rights reserved. This document contains proprietary information protected by copyright. No part of this document may be reproduced, transmitted, or made available directly or indirectly to a third party without the express written agreementof TEMENOS UK Limited. Receipt of this material directly from TEMENOS UK Limited constitutes its express permission to copy. Permission to use or copy this document expressly excludes modifying it for any purpose, or using it to create a derivative therefrom. Acknowledgements Information regarding Unicode has been provided in part courtesy of the Unicode Consortium. The Unicode Consortium is anon-profit organization founded to develop, extend and promote use of the Unicode Standard, which specifies the representation of text in modern software products and standards. The membership of the consortium represents a broad spectrum of corporations and organizations in the computer and information processing industry. The consortium is supported financially solely through membership dues.Membership in the Unicode Consortium is open to organizations and individuals anywhere in the world who support the Unicode Standard and wish to assist in its extension and implementation. Portions of the information included herein regarding IBM’s ICU has been reprinted by permission from International Business Machines Corporation copyright 2001 jBASE, jBASIC, jED, jSHELL, jLP, jEDI, jCL, jQL,j1, j2 j3 j4 and jPLUS files are trademarks of TEMENOS Holdings NV. REALITY is a trademark of Northgate Solutions Limited. PICK is a trademark of Raining Data Inc. All other trademarks are acknowledged. Java and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries. Windows, Windows NT, and Excel are eitherregistered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. UNIX is a registered trademark in the United States and other countries licensed exclusively through X/Open Company Limited. Other company, product, and service names used in this publication may be trademarks or service marks of others.

TEMENOS Manuals

i

JBASE Query LanguagejQL

Errata and Comments If you have any comments regarding this manual or wish to report any errors in the documentation, please document them and send them to the address below: Technical Publications Department TEMENOS UK Limited 6th Floor Kodak House Hemel Hempstead Hertfordshire HP1 1JY England Tel SB: +44 (0) 1442 411800 Direct Fax: +44 (0) 1442 411808 +44 (0) 1442 411900

Pleaseinclude your name, company, address, and telephone and fax numbers, and email address if applicable. documentation@temenos.com

ii

TEMENOS Manuals

JBASE Query Language

jQL

Contents

Organization of This Manual........................................................................................................... viii Documentation Conventions.............................................................................................................. ix Multivalued Files .............................................................................................................................. 2

JQL VERBS...............................................................................................................4
The @ID Field.................................................................................................................................. 6 The @ID Synonym ........................................................................................................................... 6 Entering a jQL Command Sentence .................................................................................................. 7

GENERAL RULES FOR JQL...