IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

EAZytrieve Sort: UNABLE TO RECOGNIZE STATEMENT


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Madhu Reddy

New User


Joined: 28 Sep 2006
Posts: 56

PostPosted: Fri Jun 22, 2007 11:48 am
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: 3156
Location: Tucson AZ

PostPosted: Fri Jun 22, 2007 1:09 pm
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
Search our Forums:

Back to Top