Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
PARAMETER 'F1' IS UNIDENTIFIED error in Sort JCL

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Poha Eater

New User


Joined: 31 Aug 2016
Posts: 49
Location: India

PostPosted: Fri Feb 01, 2019 2:39 pm    Post subject: PARAMETER 'F1' IS UNIDENTIFIED error in Sort JCL
Reply with quote

Hi,

I have 2 Input files (say..F1 & F2). I am trying to copy matching data from File 1 & 2 based on the key and trying to override the data in File 1 from the data of File 2 when the keys are matching and also keeping the original data of File 1 when the keys are not matching.

This is the SORT card which i created :

Code:
//STEP03   EXEC PGM=SORT                                             
//SYSOUT   DD SYSOUT=*                                               
//SORTJNF1 DD DSN=T906.TEST.QUIZ015.FILE1,DISP=SHR                   
//SORTJNF2 DD DSN=T906.TEST.QUIZ015.FILE2,DISP=SHR                   
//SORTOUT  DD DSN=T906.TEST.QUIZ015.OUTFILE,DISP=(NEW,CATLG,DELETE),
//            DCB=(LRECL=80,RECFM=FB,BLKSIZE=0)                     
//SYSPRINT DD SYSOUT=*                                               
//SYSIN    DD *                                                     
  OPTION COPY                                                       
  JOINKEYS F1=SORTJNF1,FIELDS=(01,7,A,81,12,A)                       
  JOINKEYS F2=SORTJNF2,FIELDS=(01,7,A,81,12,A)                       
  JOIN UNPAIRED,F1                                                   
  REFORMAT FIELDS=(F1:1,80,?,F2:1,12)                               
  INREC IFOUTLEN=80,                                                 
  IFTHEN=(WHEN=(81,1,CH,EQ,C'B'),OVERLAY=(10:82,12))                 
/*                                                                   




But when i am doing jcl scan to check any error. This is the error i am getting :
Code:

   SEV  MSG NO.  MESSAGE TEXT                       
-----------------------------------------------------
E1  8 DSS10065E  PARAMETER 'F1' IS UNIDENTIFIED.     
E2  8 DSS10065E  PARAMETER 'F2' IS UNIDENTIFIED.     


I have never seen this error before while using SORT JOIN. I have also searched for this error but have not found anything regarding this error. So could someone please point it out what i am missing here.
Back to top
View user's profile Send private message

Garry Carroll

Senior Member


Joined: 08 May 2006
Posts: 1046
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Fri Feb 01, 2019 3:19 pm    Post subject:
Reply with quote

There's no F1 or F2 parameter in any of your JCL. Your scan may be trying to check your SORT control cards.

Garry
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10562
Location: italy

PostPosted: Fri Feb 01, 2019 3:57 pm    Post subject: Reply to: PARAMETER 'F1' IS UNIDENTIFIED error in Sort JCL
Reply with quote

that' s NOT a jcl error,
the jcl checker used is not worth the money Your organisation pays

search the forum and You will see that the F1 and F2 specifications are right, or ...
RTFM

from the dfsort smarts tricks

Code:
//JK1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//IN1 DD DSN=... file 1
//IN2 DD DSN=... file 2
//OUT DD DSN=... output file
//SYSIN DD *
 JOINKEYS F1=IN1,FIELDS=(1,3,A),SORTED
 JOINKEYS F2=IN2,FIELDS=(1,3,A),SORTED
 REFORMAT FIELDS=(F1:1,9,F2:5,5)
 OPTION COPY
 OUTFIL FNAMES=OUT,BUILD=(1,9,X,10,5)
Back to top
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 707
Location: The Universe

PostPosted: Fri Feb 01, 2019 5:02 pm    Post subject: Re: PARAMETER 'F1' IS UNIDENTIFIED error in Sort JCL
Reply with quote

Poha Eater wrote:
...
Code:

   SEV  MSG NO.  MESSAGE TEXT                       
-----------------------------------------------------
E1  8 DSS10065E  PARAMETER 'F1' IS UNIDENTIFIED.     
E2  8 DSS10065E  PARAMETER 'F2' IS UNIDENTIFIED.     
This is not an IBM error. It is an error from your JCL checker. See if you can find the error in your JCL checker documentation.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10562
Location: italy

PostPosted: Fri Feb 01, 2019 8:26 pm    Post subject: Reply to: PARAMETER 'F1' IS UNIDENTIFIED error in Sort JCL
Reply with quote

Quote:
This is not an IBM error. It is an error from your JCL checker. See if you can find the error in your JCL checker documentation.


it is NOT even an error , if You trust the various example posted by Frank Yaeger

It is an error OF the JCL checker.
most jcl checkers give false positives on the various utility control statements
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2104
Location: NY,USA

PostPosted: Fri Feb 01, 2019 8:47 pm    Post subject:
Reply with quote

Try mapping it this way instead of what you did and if you still get the same issue then test the SORT CARD bypassing the JCL SCAN and report that SCAN issue to the right team to fix it.
Code:
JOINKEYS FILE=F1
JOINKEYS FILE=F2
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10562
Location: italy

PostPosted: Fri Feb 01, 2019 8:53 pm    Post subject: Reply to: PARAMETER 'F1' IS UNIDENTIFIED error in Sort JCL
Reply with quote

why keeping beating a dead horse ...

from a dfsort perspective there is nothing wrong with the control statement

jcl checker positives should be filtered by good judgement and experience
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2104
Location: NY,USA

PostPosted: Fri Feb 01, 2019 8:56 pm    Post subject:
Reply with quote

I have suggested what manual says about how to use JOINKEYS STATEMENT when datasets DD NAMEs are defined with SORTJNF1 and SORTJNF2.

You might be right but I still believe it’s worth of try before assuming anything is dead.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10562
Location: italy

PostPosted: Fri Feb 01, 2019 9:21 pm    Post subject: Reply to: PARAMETER 'F1' IS UNIDENTIFIED error in Sort JCL
Reply with quote

see here for the syntax of the joinkey statement

https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.3.0/com.ibm.zos.v2r3.icea100/ice2ca_JOINKEYS_statements.htm

nowhere in the manual is said about
Code:
JOINKEYS F1=SORTJNF1               
JOINKEYS F2=SORTJNF2     

being wrong
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2104
Location: NY,USA

PostPosted: Fri Feb 01, 2019 9:26 pm    Post subject:
Reply with quote

Please also see these examples how it’s used and I just did the same reference. Why do you think what I said is incorrect ? If you execute that it will work.
https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.3.0/com.ibm.zos.v2r3.icea100/ice2ca_Example_1_-_Paired_F1_F2_records_without_duplicates.htm
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10562
Location: italy

PostPosted: Fri Feb 01, 2019 10:12 pm    Post subject: Reply to: PARAMETER 'F1' IS UNIDENTIFIED error in Sort JCL
Reply with quote

I said NOTHING about You being wrong ...

I was ONLY and ONLY considering and commenting about

the false positive as reported from the jcl checker

and the manual

PS ...

on a forum generally the sentences like

see here for the syntax of the joinkey statement
- and a link -

are addressed to the TS
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2104
Location: NY,USA

PostPosted: Fri Feb 01, 2019 11:03 pm    Post subject:
Reply with quote

It is clearly stated how JOINKEYS DD NAMES are to be referenced. It is said that if you are using SORTJNF1/F2 then JOINKEYS statements has to be followed by FILE=1/2 or FILES=1/2 and any other ddname is used instead of SORTJNF1/2 but that should be followed by F1/F2= ddname.
https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.3.0/com.ibm.zos.v2r3.icea100/ice2ca_JCL_for_a_JOINKEYS_application.htm

Also, if you think F1=SORTJNF1 use is allowed (because directly it’s not said not allowed) then JCL SCAN is wrong as outlined by you otherwise No. So TS needs to test the jcl first and update us.
Back to top
View user's profile Send private message
sergeyken

Active User


Joined: 29 Apr 2008
Posts: 400
Location: Maryland

PostPosted: Sat Feb 02, 2019 2:14 am    Post subject:
Reply with quote

Initially all SORT utilities accepted only one format:
Code:
 JOINKEYS FILE=F1
 JOINKEYS FILE=F2

Once upon a time new format had been introduced in one of updated SORT version:
Code:
 JOINKEYS F1=ddname1
 JOINKEYS F2=ddname2

The updated version(s) of SORT do accept both formats, while the older versions accept only the original one.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2104
Location: NY,USA

PostPosted: Sat Feb 02, 2019 10:17 am    Post subject:
Reply with quote

By now we and TS as well known that JOINKEYS F1=ddname is allowed. The real question here is as per the links shared above and my understanding if ddname is SORTJNF1 then it’s not allowed but for any other name it’s has no issues and that’s why JCL SCAN gave the error.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2134
Location: UK

PostPosted: Sat Feb 02, 2019 3:18 pm    Post subject: Reply to: PARAMETER 'F1' IS UNIDENTIFIED error in Sort JCL
Reply with quote

The rel problem is that it is a JCL checker producing the messages not a utility control statement checker. I TS does not want the control statementrs checked then he should put hem nto a data set / member and reference that instead.

Topic locked as TS has not come back with any further information.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Build Dynamic Sort output and limit '... balaji81_k DFSORT/ICETOOL 1 Sat Feb 02, 2019 4:40 am
No new posts SORT INNER JOIN [F1] OUT OF SEQ ERROR balaji81_k DFSORT/ICETOOL 8 Wed Jan 30, 2019 3:21 am
No new posts Dates compare on specific dates using... balaji81_k DFSORT/ICETOOL 2 Thu Jan 24, 2019 12:03 am
No new posts Error when compiling a REXX exec with... Ricardo Viegas CLIST & REXX 2 Tue Dec 18, 2018 5:44 am
No new posts Joining 2 records to 1 using Sort cmuncan DFSORT/ICETOOL 1 Sat Dec 08, 2018 8:53 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us