Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 10232
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: 4648
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: 6966
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: 10232
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 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
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm
No new posts Remove Special Characters from Mainfr... Rodger Zhang All Other Mainframe Topics 6 Wed Jul 06, 2016 1:12 am
No new posts Check special resource availability w... pinimo JCL & VSAM 8 Fri Apr 15, 2016 8:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us