Ezytrieve output redirecting

poshabrar · New User Joined: 10 Jul 2006 Posts: 23

I have an ezytrieve program which creates REPORT in this format

COMPANY NAME

ADDRESS

1234 -------->:employee ID:
Current EMployee salary = 2000
Hike given=500

1235 -------->:employee ID:
Current EMployee salary = 2500
Hike given=800

.
.
.
.

it contains N records of this format in the report.

My objective is to pick the data from this report and write it so some sequential file(PS)

The resulting PS should look like
1234 2000 500
1235 2500 800
.
.
.
.

Can any one suggest how to accomplish this.

I will really appreciate if you could write the code for this task

amrita.chatterjee · Posted: Mon May 28, 2007 4:29 pm

can you please post a snapshot of the report generated by the EZYtrive Module?

William Thompson · Posted: Mon May 28, 2007 5:04 pm

Check your manual, there are control points in report generation available for detail lines, you can output from there.

poshabrar · New User Joined: 10 Jul 2006 Posts: 23

Hi Willaim,

Can you please be more specific, I am trying this out for the first time.

William Thompson · Posted: Mon May 28, 2007 5:14 pm

Have you check your manuals? I think the application guide might give the best example.....

Devzee · Posted: Mon May 28, 2007 11:13 pm

If the report file created by your EZT code is not used by any one, then you can change your EZT code to write to an output file in whatever format is required, or create new output file and create the requred format.

poshabrar · New User Joined: 10 Jul 2006 Posts: 23

Will I just have to redirect the output by changing the SYSOUT in my JCL? what changes do i have to make in my ezytrieve program.?

Devzee · Posted: Tue May 29, 2007 9:49 am

If you want to create one more output file with just required data , then you got to make changes in your code to write to new output file.

poshabrar · New User Joined: 10 Jul 2006 Posts: 23

Devzee,

Can you please pass on some sample code. I am very new to ezytrieve and I have no manuals to go thru..

Devzee · Posted: Tue May 29, 2007 10:23 am

By looking at any of your existing code you can easily make changes.

1. Write 1 line of File declaration
2. And then before or after current PRINT statement move to output area, and do PUT
3. In JCL code a dd name for your new file name

Even If you are new you can look at the code and can easily understand Easytrieve syntax and flow..

William Thompson · Posted: Tue May 29, 2007 3:49 pm

poshabrar · New User Joined: 10 Jul 2006 Posts: 23

On your suggestion I have declared a file with name OUTCLT.

PARM SSID('DB2T')
FILE OUTCLT
FILE OUTRPT PRINTER

I have included the PUT stmt before the Print stmt

PUT OUTCLT

PRINT MADRPT

When I compile the program it shows up this error

76 *******A001 FILE OPEN ERROR - OUTCLT
*******A014 PREMATURE TERMINATION DUE TO PREVIOUS ERROR

Please advice.

Devzee · Posted: Tue May 29, 2007 6:15 pm

Have you coded OUTCLT DD name in JCL ?

poshabrar · New User Joined: 10 Jul 2006 Posts: 23

YEs i did

And on line 76 in EZYTRIEVE I have the following code

JOB INPUT NULL NAME MAIN-PROCESS START START-PROC

I guess the error message relates to this line. Isn't it?

IQofaGerbil · Posted: Thu May 31, 2007 2:49 pm

A001 FILE OPEN ERROR - filename

The operating system detected an error while attempting to open the indicated file.
The file remains unopened and the job is terminated.
Validate the
existence and characteristics of the actual file.
Make sure that the characteristics of the file match those parameters specified on the FILE statement.

Done all that?

poshabrar · New User Joined: 10 Jul 2006 Posts: 23

I have made changes...... But this time it runs with return code of Zero but doesn't write any records to the file.

dick scherrer · Posted: Thu May 31, 2007 6:28 pm

Hello,

It may help if you post your jcl and the code that references the new output file.