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: 2089
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 DB2 Timestamp field weird behaviour. rizwanaccy DB2 7 Wed Dec 26, 2018 4:33 pm
No new posts MQ-DATA-LENGTH is ZERO on MQGET Daniel Prosser Java & MQSeries 5 Tue Dec 18, 2018 5:41 pm
No new posts Problem with OVERLAY - BI on SMF Record Ghellar DFSORT/ICETOOL 4 Sat Dec 01, 2018 9:41 pm
No new posts To get the count of PDS data sets whi... Vignesh Sid JCL & VSAM 4 Fri Nov 30, 2018 8:38 pm
No new posts DB2 - loading data Joshua1066 DB2 5 Sun Nov 18, 2018 4:58 am

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