Elimiating Junk data fetched from Database

This is a Mainframe COBOL forum - you can post your queries on Mainframe COBOL, VS COBOL II, COBOL/370 , Enterprise COBOL

Moderators: dbzTHEdinosauer, Moderator Group

Post Reply
ajit5144
Member
Posts: 6
Joined: Sun Mar 17, 2013 11:27 pm
Location: Chennai

Elimiating Junk data fetched from Database

Post by ajit5144 » Wed Jul 17, 2013 9:17 pm

Hi,

During a retrieval process from IMS database , I got some values from database, which are junk.The value's are displayed as spaces, But hex on shows them as hex'0000' instead of hex '4040" which is value for spaces.

My layout and Database layout matches . Also, I have a check for Low values in my retrieval program, But,it is not working.

Can anyone suggest , How to eliminate these values.

Thanks,
Ajit

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Thu Jul 18, 2013 1:01 am

Sounds like the data is neither all spaces nor all x'00'.

You need to hex dump and post a few of these invalid values, the code that describes them, and the code that uses them.
Have a good one

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others