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
 
Extra data in overlay field

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

New User


Joined: 27 Aug 2008
Posts: 22
Location: USA

PostPosted: Thu Sep 13, 2018 6:04 pm    Post subject: Extra data in overlay field
Reply with quote

The field with extra data is starting in 105 and is the OVERLAY field. other data looks good.

I have sort card as:
Code:
 
SORT FIELDS=(1,2,CH,A,3,3,CH,A)                                     
OUTREC IFTHEN=(WHEN=INIT,                                           
       BUILD=(001:001,02,    -- CNY_CD                               
              003:003,03,    -- CNY_NUM_CD                           
              006:155,02,    -- IRS_CNY_CD                           
              008:064,55,    -- CNY_NM                               
              063:024,40,    -- CNY_COM_NM                           
              103:+055,TO=BI,LENGTH=2, -- STDPY_CNTY_NM_LEN         
              105:064,55,    -- STDPY_CNTY_NM_TXT                   
              205:161,1,     -- US_TRR_CD                           
              206:SEQNUM,4,BI,START=1,INCR=1, -- DISPLAY_SEQ_ NO     
              234:+20,TO=BI,LENGTH=2,    -- ROW_LUP_USR_ID_LEN       
              236:C'GPA026PD')), -- ROW_LUP_USR_ID_TXT               
       IFTHEN=(WHEN=(205,1,CH,EQ,C'Y'),                             
              OVERLAY=(103:+100,TO=BI,LENGTH=2,                     
                       105:C'U.S. TERRITORY - ',063,55))             


Input is:
Code:

AS161 161016AAMER SAMOAAMERICAN SAMOA                          AMERICAN SAMOA 


Output is:

    U.S. TERRITORY - AMERICAN SAMOA ..U.S. TERRITO


I want
    U.S. TERRITORY - AMERICAN SAMOA

where is the ..U.S. TERRITO coming from. I am just NOT seeing it icon_sad.gif HELP....
Back to top
View user's profile Send private message

speermb

New User


Joined: 27 Aug 2008
Posts: 22
Location: USA

PostPosted: Thu Sep 13, 2018 7:28 pm    Post subject: fOUND IT
Reply with quote

I JUST NEED TO USE THE RIGHT LENGTH IN THE OVERLAY...I WAS USING THE WRONG LENGTH!! I HAD
Quote:

IFTHEN=(WHEN=(205,1,CH,EQ,C'Y'),
OVERLAY=(103:+100,TO=BI,LENGTH=2,
105:C'U.S. TERRITORY - ',063,55))


SHOULD BE
Quote:

IFTHEN=(WHEN=(205,1,CH,EQ,C'Y'),
OVERLAY=(103:+100,TO=BI,LENGTH=2,
105:C'U.S. TERRITORY - ',063,40))

[/quote]
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


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

PostPosted: Thu Sep 13, 2018 7:31 pm    Post subject:
Reply with quote

So you got it figured out by your self. Well done.
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
This topic is locked: you cannot edit posts or make replies. DFSORT output in CSV for data spans i... hiravibk DFSORT/ICETOOL 3 Tue Nov 13, 2018 7:55 pm
No new posts REFORMATTING WITH JFY CLOBBERING OUTP... speermb DFSORT/ICETOOL 12 Thu Nov 08, 2018 7:20 pm
No new posts Migrating AS400 to HIVE; Data type ma... sindhu.jose All Other Mainframe Topics 1 Tue Nov 06, 2018 1:06 pm
No new posts Merge data from record pairs ashokakash DFSORT/ICETOOL 5 Wed Oct 17, 2018 11:38 am
No new posts Calling and updating SAS Macro variab... Yogesh Jaiswal All Other Mainframe Topics 7 Thu Oct 11, 2018 12:37 pm

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