How to Write a Simple Easytrieve Program. Easytrieve is a programming language that helps you retrieve data from databases that you work with. However, when you are working with databases that are public they are usually time sensitive so you need to get in and out as quickly as possible. The following will give you the basics of how to write a simple Easytrieve program.
|Published (Last):||28 February 2007|
|PDF File Size:||8.95 Mb|
|ePub File Size:||5.36 Mb|
|Price:||Free* [*Free Regsitration Required]|
CA-Easytrieve is an information retrieval and data management system designed to simplify computer programming. Its English-like language and simple declarative statements provide the new user with the tools needed to produce comprehensive reports and screens with ease, while its enhanced facilities provide the experienced data processor with the capabilities to perform complex programming tasks.
The output can be either returned to your terminal screen or routed to a printer. It contains descriptions of the complete syntax of each CA-Easytrieve statement, organized in easy-to-find alphabetical order. It also provides:. This guide is to be used by programmers using the following implementations of CA-Easytrieve:. This guide is divided into seven chapters and three appendices:. Chapter 2, Statement Summaries Provides two types of quick reference summaries:. Index Provides a quick way to find references to functions, procedures, and terms.
User Guide. Also, how to compile and execute interactively using an editor and how to use. Provides new users with the. Introduction to the information to become. Language Guide. Includes a tutorial designed to make the material more interesting and easy to comprehend. CA-Easytrieve Programmer Guide. How to apply these programs to various application tasks. The most current step-by-step installation procedures for your environment s can be found on the product tape. Installation Guide. The following publications, produced by Computer Associates, are either referenced in this publication or are recommended reading:.
The following publications, not produced by Computer Associates, are either referenced in this publication or are recommended reading:. The following conventions are used throughout this guide for illustrative purposes:. Mandatory choice of one of these entries. Optional entry or choice of one of these entries. OR bar. Choice of one of these entries.
Ellipses indicate that you can code the immediately preceding parameters multiple times. Bold text in program code is used to highlight an example of the use of a statement.
All capital letters indicate a CA-Easytrieve keyword, or within text descriptions, indicate a name or field used in a program example. Lowercase italics represent. The following lists summarize the technical changes and enhancements provided in version upgrades of CA-Easytrieve. Screen generation and maintenance assisted by Screen Painter. Windowed Screens. Screens can now have a border built displayed around them, whether they are full-screen applications or windows.
SET Statement. The SET statement provides an easy method to change screen attributes for. Existing users may want to add the attribute in their site options. In addition, you can load a CA-Easytrieve virtual file and browse forward and backward through the file.
These options provide the following capabilities:. Additional calculations and multiple Assignment statements previously required to perform these functions are no longer needed. Instream Macros. The compiler now supports including macro definition as part of the source program.
This capability is particularly useful for testing new macros prior to storing them in the macro library. Multiple Name Support. The terminal user is able to still see the screen display as the target program processes and is not left with a blank screen. Double Byte Character Set Support.
Kanji and mixed fields and literals can be displayed on and received from the terminal. Report Painter. A Report Painter provides a visual method for creating and maintaining. Screens and reports can be painted online using the same easy-to-use interface. Screen Painter Enhancements. A new Field Select window is available to display program fields for selection from other windows and lists. Editor CAPS setting. CASE Statement. The CASE statement now supports variable length fields. If field-name is an alphanumeric literal, it no longer must be or fewer bytes in length.
SQL Processing. Extended Reporting. This facility interacts with CA-Easytrieve report processing to provide support for many additional features, such as font control. Synchronized File Processing. File Exits. Label Reports.
Even Precision for Packed Fields. Static Call Support for Subroutines. Identifiers and DBCS. Identifiers can now contain DBCS characters. Year Support. This specifies. This interface provides complete facilities for information retrieval and maintenance of SQL tables. SQL processing for Version 1. This support includes development and execution of full-screen and windowed text-based applications.
However, there is no database support. Distributable Applications. CA-Ingres Processing. Oracle Processing. DB2 Processing. The free-form English language structure of CA-Easytrieve makes it easy for you to develop an efficient, flexible programming style. To avoid programming errors, follow the simple syntax rules of CA-Easytrieve.
All source statements are records of 80 characters each. A system installation option establishes a statement area within the 80 available positions. The default statement area is in columns 1 through This allows for optional data for example, sequence numbers and program identifiers to be entered on the record, but still be ignored by CA-Easytrieve. The complete record is always printed on the statement listing. Character Sets. MIXED data format is supported only to the. CA-Easytrieve supports both character sets based upon the following assumptions and rules:.
DBCS data in the CA-Easytrieve statement area is not processed for continuation characters, delimiters, words, identifiers, and so on. A DBCS character occupies two bytes in storage. This system, called the Wrapping shift code system, takes the form of two codes -- one code preceding and the second following the DBCS data.
These codes can be one or two bytes in length. The following illustrates the use of the Wrapping shift code system:. A shift code is a special one or two byte character contained in the CA-Easytrieve statement area.
Each shift code value uniquely identifies the DBCS code system of the data. If the system cannot be uniquely identified, a default is assumed. You can alter this default at compile time using the PARM statement. The CA-Easytrieve compiler identifies the statement containing the word and when necessary, performs the required processing to remove the shift codes and convert EBCDIC data. The statement area normally contains a single statement. However, you can enter multiple statements on a single record.
The character string '.
Language English. Product Menu Topics. In this lesson, we show you a sample program that you can enter and run on your computer. However, you can follow the lessons in this tutorial without running the programs to learn the product. Sample Program. This sample program has only ten lines of code, but it creates a useful report.
How to Write a Simple Easytrieve Program
Language English. Product Menu Topics. Getting Started. Tutorial and overview of program sections. CA Easytrieve runs interactively for data inquiry, analysis, maintenance, and reporting. The output can be returned to your terminal or routed to a printer.