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
 
supressing the null and special chartacter

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
Kamlesh Kamal

New User


Joined: 16 May 2008
Posts: 36
Location: Kolkata,India

PostPosted: Fri Jul 24, 2009 8:14 pm    Post subject: supressing the null and special chartacter
Reply with quote

Hi ,

I am getting values in my report file as . . AND . . MUT FUND my requirement is to supress these.

Like for . . I should have spaces and for . .MUT FUND I should get only MUT FUND

I have tried checking for NULL VALUES ,LOW AND HIGH VALUES but that didn't work.The hex equivalent for the first byte is 00 and for the second is 1E(which measns a record separator in CHAR)

Can anyone tell me how can I suppress it?The value is as under

PROD TYP CD
.. should be spaces here
.. should be spaces here
..MUT FUND should be MUT FUND here like below
MUT FUND

Please note that these are not NULL values as I said first DOT is 10 in hex and second one is 1E in hex..
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10375
Location: italy

PostPosted: Fri Jul 24, 2009 8:30 pm    Post subject: Reply to: supressing the null and special chartacter
Reply with quote

what application generates the dataset ??
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Fri Jul 24, 2009 8:39 pm    Post subject: Reply to: supressing the null and special chartacter
Reply with quote

Kamlesh, let's go over some of the "rules" for posting in the "Interview Questions" forum:

1. You need to post both the question that was asked and the answer you gave, and the reason you think that your answer is the right one. A forum member can tell you if they think you were right or if you were wrong and if so, why.

2. We need to know the scope of the question. What is it concerning (a specific language, a specific process, a specific technology, etc.). What level of a position is the question supposed to be for (beginner, intermediate, expert)?

Thanks for your cooperation.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Fri Jul 24, 2009 9:00 pm    Post subject:
Reply with quote

Quote:
not NULL values


there is no such thing......................
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10375
Location: italy

PostPosted: Fri Jul 24, 2009 9:46 pm    Post subject: Reply to: supressing the null and special chartacter
Reply with quote

Quote:
I am getting values in my report file as . . AND . . MUT FUND my requirement is to supress these.

Like for . . I should have spaces and for . .MUT FUND I should get only MUT FUND
from the posting style does not look like an interview question icon_smile.gif
let's wait for the TS to clarify the issue
Back to top
View user's profile Send private message
Kamlesh Kamal

New User


Joined: 16 May 2008
Posts: 36
Location: Kolkata,India

PostPosted: Mon Jul 27, 2009 2:13 pm    Post subject:
Reply with quote

Sorry for the confusion..

It was not an interview question really..it was the problem I was facing during my cobol programming which genarates a file reading a table and I am getting those invalid chars in one of my fields of the file..i have posted the same query under the mainframes cobol index now...

Once again sorry for the confusion..
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am

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