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: 356
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: 1542
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: 356
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 question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts QUESTION: RETURN CHANNEL pahiker CA Products 21 Thu Apr 20, 2017 12:31 am
No new posts The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am

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