Junk Value in Database

syed-sameer-ahmed · New User Joined: 22 Feb 2007 Posts: 45 Location: Bangalore

Hi,

I have a DB where there are lot of junk values in many fields.

how can I fetch the fields with junk Value in it?

Thanks,

SAMeer

Craq Giegerich · Posted: Wed May 19, 2010 10:54 pm

What are "junk values" and how did they get there?

enrico-sorichetti · Posted: Wed May 19, 2010 11:00 pm

define junk values

Anuj Dhawan · Posted: Thu May 20, 2010 3:04 pm

syed-sameer-ahmed · New User Joined: 22 Feb 2007 Posts: 45 Location: Bangalore

I define Junk values are which are not recognisable by the system.

For example Hex code of Spaces is X'40' where are X'00' is undefined and cannot be handled in the Datastream and throws a XPROG 752 error.

I want to handle this condition in the program and replace the junk value bu space.

Thanks

enrico-sorichetti · Posted: Mon May 31, 2010 6:45 pm

CICS Guy · Posted: Mon May 31, 2010 6:57 pm

syed-sameer-ahmed · New User Joined: 22 Feb 2007 Posts: 45 Location: Bangalore

but I how do I identify the junk values. X'00' is not the only one,how do I test the Validity of the character in Database.

Let me know If I am confusing. the problem is not only at a specific place,it is occurring at random places.

so I need to know how to handle it.

Thanks

dbzTHEdinosauer · Posted: Mon May 31, 2010 7:11 pm

syed-sameer-ahmed · New User Joined: 22 Feb 2007 Posts: 45 Location: Bangalore

Yes,my question is "how do I recognise the invalid characters in DB and in Cobol program,as I dont know what other values it can be ?"

I hope I am able to explain.

Robert Sample · Posted: Mon May 31, 2010 9:22 pm

Syed Sameer Ahmed, it sounds like you want a quick and easy way to recognize and correct the data causing your CICS BMS problems. Unfortunately, once this data has been allowed into your data base, there are NO QUICK,EASY SOLUTIONS to your problem. The best long-term solution is to scrub the data in the data base, removing or changing all data that should not be there. Yes, this takes a long time and is very expensive -- but it is the only sure-fire solution.

You can analyze the fields in the data base, determine which characters are invalid for your map, and handle them one by one in your program before putting the data on the map. This requires effort on your part, and any characters you miss will continue to impact your program.

geekram · Posted: Mon May 31, 2010 9:43 pm

If you know the JUNK Characters in the database then you can replace them. If you dont know what all the JUNK characters that are going to come into or out from database then i think the best solution is the handle it in the application program.

Another most important is what are all the characters do you define as JUNK? There should be some boundaries set for the JUNK characters. In some scenarios some characters may be valid and in some other cases the same characters may be valid ones. So if we know what all characters you consider as JUNK then we can code the application program accordingly.
Anyways thats a good questions. Let me know your views what you think.

Thanks!

Cheers,
Ram.

dick scherrer · Posted: Mon May 31, 2010 9:55 pm

Hello,

Rather than trying to identify each and every invalid value, suggest the alternative - identify the valid values and change everything else to a space. . .

Then send the map. . .

CICS Guy · Posted: Mon May 31, 2010 10:05 pm

There are only a few 3270 opcodes, and IIRC, only the SBA is the one that would cause your XPROG error. You might try a simple inspect/replacing on the fields with the junk before/after moving them to the map.

syed-sameer-ahmed · New User Joined: 22 Feb 2007 Posts: 45 Location: Bangalore

Thanks for your Advise and solution,but the problem stands as it is.

Let me try this :
I'll inspect and move them if they are not alpha or numeric or symbols.

Can this be done?

I'll let you know the challenged I face on the way.

Thanks again.

enrico-sorichetti · Posted: Tue Jun 01, 2010 12:18 pm

Pravesh · New User Joined: 30 Jul 2009 Posts: 32 Location: Gurgaon

Use 'Is Numeric' clause on the numeric field

Rgds,
Pravesh

dick scherrer · Posted: Tue Jun 01, 2010 8:29 pm

Hello,

Marso · Posted: Tue Jun 01, 2010 9:28 pm

syed-sameer-ahmed,
are you sure the working-storage area receiving the data is in sync with the DB2 fields ?
If you have FETCH cursorname INTO :GROUP-FIELD and if the fields in the group do not exactly correspond to the DB2 columns, then it may look like junk.