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
 
What is the Question Mark (?) meaning in DFSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Wed Jun 19, 2013 4:22 pm    Post subject: What is the Question Mark (?) meaning in DFSORT
Reply with quote

HI,

We have a code as below...

Code:

JOINKEYS F1=IN1,FIELDS=(1,18,A) 
JOINKEYS F2=IN2,FIELDS=(4,18,A) 
JOIN UNPAIRED,F2                 
REFORMAT FIELDS=(F2:1,457,?)     
OPTION COPY                     


I know the meaning of all other but can I know what the below question Mark (?) denotes here?

Code:

REFORMAT FIELDS=(F2:1,457,?)


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

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1561
Location: Andromeda Galaxy

PostPosted: Wed Jun 19, 2013 4:46 pm    Post subject:
Reply with quote

Code:
//STEP0100 EXEC PGM=SORT
//SYSOUT   DD SYSOUT=*
//INA      DD *
AAA
ACC
BBB
CBB
DBB
EBB
FBB
//INB      DD *
AAA
BCC
BBB
CBB
DBB
EBB
FBB
//SORTOUT  DD SYSOUT=*
//SYSIN    DD *
  OPTION COPY
  JOINKEYS F1=INA,FIELDS=(1,5,A)
  JOINKEYS F2=INB,FIELDS=(1,5,A)
  JOIN UNPAIRED F1,F2
  REFORMAT FIELDS=(F1:1,5,F2:1,5,?)
//*


Gives an output

Code:
AAA  AAA  B
ACC       1
BBB  BBB  B
     BCC  2
CBB  CBB  B
DBB  DBB  B
EBB  EBB  B
FBB  FBB  B


So using ? in reformat could get you three possible values B,1,2

B - When key is found in both files
1 - When key found in first file only
2 - When key found in second file only
Back to top
View user's profile Send private message
Gary McDowell

Active User


Joined: 15 Oct 2012
Posts: 139
Location: USA

PostPosted: Wed Jun 19, 2013 4:51 pm    Post subject:
Reply with quote

This link may help...
http://publib.boulder.ibm.com/infocenter/zos/v1r12/topic/com.ibm.zos.r12.icea100/ice1ca50118.htm?resultof=%22%52%45%46%4f%52%4d%41%54%22%20%22%72%65%66%6f%72%6d%61%74%22%20
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Fri Jun 21, 2013 12:04 am    Post subject:
Reply with quote

Read upon the 4.5 REFORMAT Statement in the following link which explains in detail about the Joinkeys parameters.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA60/4.0?
Back to top
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Fri Jun 21, 2013 5:16 pm    Post subject:
Reply with quote

Thank you for all replies.
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 -> 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 Generate and submit JCL and step dyna... vnktrrd DFSORT/ICETOOL 11 Wed Jul 25, 2018 11:31 pm
No new posts How to Count a particular record in a... Mounika Nemani DFSORT/ICETOOL 5 Tue May 29, 2018 1:07 pm
No new posts Question about dataset sequence numbe... harisukumaran JCL & VSAM 23 Tue May 29, 2018 9:31 am
No new posts Need urgent suggestion on DFSORT subratarec DFSORT/ICETOOL 6 Wed Mar 21, 2018 8:46 pm
No new posts JES2 EXIT 6 QUESTION Randy Horowitz All Other Mainframe Topics 30 Tue Feb 06, 2018 5:47 pm

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