Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum 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: 28
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: 28
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: 2247
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
No new posts How to force ISPF to allocate ISPF te... Michele Giannuli TSO/ISPF 9 Thu Sep 12, 2019 2:03 pm
No new posts Need to fetch data from database base... Satandale COBOL Programming 8 Sun Sep 08, 2019 12:01 am
No new posts How to append data from PARM in OUTFIL Poha Eater DFSORT/ICETOOL 17 Thu Aug 22, 2019 4:03 pm
No new posts Training on numeric fields data formats sergeyken SYNCSORT 12 Thu Aug 01, 2019 8:15 pm
No new posts Can I use Tableau/PowerBI kind data a... rohanthengal All Other Mainframe Topics 2 Wed Jul 24, 2019 4:43 pm

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