View previous topic :: View next topic
|
Author |
Message |
begginer
New User
Joined: 27 Feb 2009 Posts: 3 Location: India
|
|
|
|
Hi,
I am inserting some values in a table using cobol. It has been seen that there is junk value appended to the input which has been feeded while checking in the table. Is there any way using inspect to remove these junks in data.
Thank You |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Define what is JUNK? |
|
Back to top |
|
|
Mathiv Anan
Active User
Joined: 23 Jul 2008 Posts: 106 Location: USA
|
|
|
|
I think you can intialize the table before loading it.
It would be better if you give the table structure, input fields that are loaded into the table fields etc, |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
initializing the table will not help if the 'junk' is coming from another source.
insure that the data definitions for the input and the table match.
if you have 'junk' (unwanted data) in your input, you will have to fix that, either thru your input cobol program or the during the creation process of your input file.
but, we have no idea what you are doing. a little more explanation will help. |
|
Back to top |
|
|
Bill O'Boyle
CICS Moderator
Joined: 14 Jan 2008 Posts: 2501 Location: Atlanta, Georgia, USA
|
|
Back to top |
|
|
begginer
New User
Joined: 27 Feb 2009 Posts: 3 Location: India
|
|
|
|
I am inserting numeric values into the table (issue is with numeric fields only, characters are all inserted good), The JUNK here is supposed to be numeric value (8080 here) appended to every numeric input. I am removing all the leading zeroes and there aint any junk value when displaying them before insertion.
Thanks in anticipation |
|
Back to top |
|
|
senthilnathanj
New User
Joined: 31 Jul 2007 Posts: 47 Location: chennai
|
|
|
|
if you are inserting a numeric value in the table.it will display the correct value . you can put in the command line HEX. it will display the value in the hexadecimal format.using COMP fields are binary format.
some of the variable using COMP-3 field displayed in the packed decimal.
you can convert the hexadecimal to binary format manually..
for example if u want to insert the numeric value 23 means
if iam wrong please correct it... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Show the input data definition, the input data in hex, the output (array/table) definition, and the code that moves the data from the input to the table. |
|
Back to top |
|
|
begginer
New User
Joined: 27 Feb 2009 Posts: 3 Location: India
|
|
|
|
Thank You guys, the problem was with the table. It has been sorted out !! |
|
Back to top |
|
|
|