How to Write a Simple Easytrieve Program. Understand what you need. Make sure you understand the scope of the job. The simplest way to extract data is not to limit what you draw, but cut it down later. See tips to find out why. Working with an out file is much easier and not time sensitive. Make sure you designate the database that you want to capture the data from. Easytrieve needs to know where you need to go in order to get there. When you program you are creating a map and you can't leave out any steps or you certainly won't end up where you want to be. Retrieve a copy of the layout of the database you are using. You need to know where each of the variables resides in order to know where they are when you are working with the database or outfile that you created. Create an outfile in your program. This will be the place where you send your results. Usually this file will be saved to your own pc and therefore you will have unlimited access to it and not have to worry about any time sensitivity the database has. Run the program. If there are any mistakes you will need to fix them. These could range from not indicating the database you are seeking correctly to simply wording a step incorrectly. You need to correct your mistakes and run the Easytrieve program again until you get the results you are seeking. Select the variables you need using your outfield. If your instructions only ask for data for June 2. You may also need to only capture males or females of a certain age. Whatever the limitations are you want to add them in your program before you go any farther. Add any variables that do not exist. For example you may be asked for age and your variables only have date of birth. Therefore you would need to create two variables; one for the current date and one subtracting the date of birth from the current date variable to get the age of the person. Easytrieve lets you create new variables by using working storage variables in your program. Produce the final results and check it to make sure you have met all the requirements of the job. Give them to the appropriate person. This could be your customer or your supervisor. Easytrieve logic to read a file write to an external table. EASYTRIEVE – Sample Program – Table And Search. Is it that you write embedded SQLs in the Easytrieve programs just like you do in COBOL or use some standard APIs to do the same by. Embedded DB2 SQL and Cursor in. For OS/390, VM, VSE SP3. Release 6.2, May 1996. Lesson 1: Your First CA-Easytrieve/Plus Report Program. 3–2 Report Your Program Creates. CA Products: Hello Friends, Could anyone please tell me can we use copybook(s) in easytrieve program? Write Easytrieve ProgrammingHow to Write a Simple Easytrieve Program Things You'll Need Database Customer/Assignment Layout of database Easytrieve software Instructions Understand what you need. Make sure you understand the scope of the job. CA-Easytrieve Plus Programming Performance Objectives SYS-ED/COMPUTER EDUCATION TECHNIQUES. READ, and WRITE statements. How to Write a Simple Easytrieve Program. Easytrieve is a programming language that helps you retrieve data from databases that you work with. It is an easier language to learn than COBOL or FORTRAN. However, when you are. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
August 2017
Categories |