Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Ezytrieve output redirecting

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
poshabrar

New User


Joined: 10 Jul 2006
Posts: 23

PostPosted: Mon May 28, 2007 4:03 pm    Post subject: Ezytrieve output redirecting
Reply with quote

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
Back to top
View user's profile Send private message

amrita.chatterjee

New User


Joined: 27 Apr 2006
Posts: 48
Location: Bangalore, India

PostPosted: Mon May 28, 2007 4:29 pm    Post subject: Re: Ezytrieve output redirecting.......
Reply with quote

can you please post a snapshot of the report generated by the EZYtrive Module?
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Mon May 28, 2007 5:04 pm    Post subject:
Reply with quote

Check your manual, there are control points in report generation available for detail lines, you can output from there.
Back to top
View user's profile Send private message
poshabrar

New User


Joined: 10 Jul 2006
Posts: 23

PostPosted: Mon May 28, 2007 5:11 pm    Post subject:
Reply with quote

Hi Willaim,

Can you please be more specific, I am trying this out for the first time.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Mon May 28, 2007 5:14 pm    Post subject:
Reply with quote

Have you check your manuals? I think the application guide might give the best example.....
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Mon May 28, 2007 11:13 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
poshabrar

New User


Joined: 10 Jul 2006
Posts: 23

PostPosted: Tue May 29, 2007 9:43 am    Post subject:
Reply with quote

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.?
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue May 29, 2007 9:49 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
poshabrar

New User


Joined: 10 Jul 2006
Posts: 23

PostPosted: Tue May 29, 2007 10:16 am    Post subject:
Reply with quote

Devzee,

Can you please pass on some sample code. I am very new to ezytrieve and I have no manuals to go thru..
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue May 29, 2007 10:23 am    Post subject:
Reply with quote

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..
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Tue May 29, 2007 3:49 pm    Post subject:
Reply with quote

poshabrar wrote:
I am very new to ezytrieve and I have no manuals to go thru..
Well, why didn't you say so....
dbzthedinosaur wrote:
http://www.easytrieveplus.com/prog_contents.html
http://www.easytrieveplus.com/lref_contents.html
Back to top
View user's profile Send private message
poshabrar

New User


Joined: 10 Jul 2006
Posts: 23

PostPosted: Tue May 29, 2007 4:01 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue May 29, 2007 6:15 pm    Post subject:
Reply with quote

Have you coded OUTCLT DD name in JCL ?
Back to top
View user's profile Send private message
poshabrar

New User


Joined: 10 Jul 2006
Posts: 23

PostPosted: Wed May 30, 2007 9:00 am    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 183
Location: Scotland

PostPosted: Thu May 31, 2007 2:49 pm    Post subject: Re: Ezytrieve output redirecting
Reply with quote

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?
Back to top
View user's profile Send private message
poshabrar

New User


Joined: 10 Jul 2006
Posts: 23

PostPosted: Thu May 31, 2007 5:20 pm    Post subject:
Reply with quote

I have made changes...... But this time it runs with return code of Zero but doesn't write any records to the file.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu May 31, 2007 6:28 pm    Post subject:
Reply with quote

Hello,

It may help if you post your jcl and the code that references the new output file.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts output data in CSV Format janmejay COBOL Programming 8 Sat Oct 15, 2016 2:20 pm
This topic is locked: you cannot edit posts or make replies. output data in CSV Format janmejay DFSORT/ICETOOL 3 Sat Oct 15, 2016 2:16 pm
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us