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
 

 

EAZytrieve Sort: UNABLE TO RECOGNIZE STATEMENT

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

New User


Joined: 28 Sep 2006
Posts: 56

PostPosted: Fri Jun 22, 2007 11:48 am    Post subject: EAZytrieve Sort: UNABLE TO RECOGNIZE STATEMENT
Reply with quote

Hi ,

The below is the Jcl Eazytrieve pgm

//SYSIN DD *
FILE DUPFILE FB(160, 1600)
DEPT 1 3 N
NAME 4 8 A
EMP# 12 6 N
GROSS 18 7 N 2
FILE PAYFILE FB(160, 1600)
DEPT 1 3 N
NAME 4 8 A
EMP# 12 5 N
GROSS 18 7 N 2
JOB INPUT DUPFILE NAME PAY-RPT
SORT DUPFILE TO PAYFILE USING DEPT
PRINT PAY-RPT
REPORT PAY-RPT LINESIZE 80
TITLE 01 'EMPLOYEE INFO'
LINE 01 DEPT NAME EMP# GROSS

When i run this code i am getting the below error
*******B014 UNABLE TO RECOGNIZE STATEMENT

Could anyone suggest me the solution

Thanks
Back to top
View user's profile Send private message

William Thompson

Global Moderator


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

PostPosted: Fri Jun 22, 2007 1:09 pm    Post subject: Re: EAZytrieve Sort: UNABLE TO RECOGNIZE STATEMENT
Reply with quote

Madhu Reddy wrote:
When i run this code i am getting the below error
*******B014 UNABLE TO RECOGNIZE STATEMENT

Quote:
B014 UNABLE TO RECOGNIZE STATEMENT - word
The indicated statement is not recognizable as a CA-Easytrieve/Plus source or control statement. The optional supplemental message indicates the invalid statement. If the supplemental message is not present, the entire jobstream is unrecognizable and the input is flushed.
Back to top
View user's profile Send private message
IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 183
Location: Scotland

PostPosted: Fri Jun 22, 2007 4:42 pm    Post subject: Re: EAZytrieve Sort: UNABLE TO RECOGNIZE STATEMENT
Reply with quote

If I understand your requirement, it is to print the input DUPFILE sorted on DEPT?

If that is corrrect then you do not need the SORT statement nor the PAYFILE.
All you need to do is insert

SEQUENCE DEPT

as the next line after the REPORT statement, Easytrieve will do the rest for you.

eg
Code:

FILE DUPFILE FB(80, 8000)                 
DEPT 1 3 N                                 
NAME 4 8 A                                 
EMP# 12 6 A                               
GROSS 18 7 A                               
JOB INPUT DUPFILE                         
PRINT PAY-REP                             
REPORT PAY-REP  LINESIZE 132 PAGESIZE 61   
SEQUENCE DEPT                             
TITLE 01 'EMPLOYEE INFO'                   
LINE 01 DEPT NAME EMP# GROSS               
Back to top
View user's profile Send private message
priyamnavada

New User


Joined: 24 Dec 2005
Posts: 52
Location: hyderabad

PostPosted: Fri Jun 29, 2007 4:03 pm    Post subject:
Reply with quote

as far as my knowledge, the file variables should be distinct. try this once- by giving different file records,....

for example,

FILE DUPFILE FB(160, 1600)
I-DEPT 1 3 N
I-NAME 4 8 A
I-EMP# 12 6 N
I-GROSS 18 7 N 2
FILE PAYFILE FB(160, 1600)
O-DEPT 1 3 N
O-NAME 4 8 A
O-EMP# 12 5 N
O-GROSS 18 7 N 2
Back to top
View user's profile Send private message
G-Johnson

New User


Joined: 12 Mar 2007
Posts: 20
Location: USA

PostPosted: Fri Jun 29, 2007 10:07 pm    Post subject:
Reply with quote

the sort has to be performed before the job statement.
Back to top
View user's profile Send private message
lcmontanez

New User


Joined: 19 Jun 2007
Posts: 50
Location: Chicago

PostPosted: Wed Jul 04, 2007 2:23 am    Post subject:
Reply with quote

priyamnavada wrote:
as far as my knowledge, the file variables should be distinct. try this once- by giving different file records,....


FYI, field names do not need to be distinct.

To reference duplicate field names prefix the name with the filename

(ex) Dupfile:Dept or Payfile:Dept
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 Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm
No new posts Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts SORT to append Month and YEAR in MMYY... tisamf DFSORT/ICETOOL 1 Wed Mar 08, 2017 4:46 pm


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