|
View previous topic :: View next topic
|
| Author |
Message |
kapil dev arora
New User
Joined: 29 Dec 2008
Posts: 37
Location: india
|
|
|
|
My online cics program abended during addition operation with -310 code.
The reason we got is when we keep the first row empty and fill second row with data its abending. But if we fill data in first row it will validate it and wont abend.
Now i need to improve the program to resolve and give a fix to it. But I am not getting how to approach for this kind of probem.
Thanks in anticipation. |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
Your explanation is confusing 
what does the manual say about -310 ?? |
|
| Back to top |
|
|
kapil dev arora
New User
Joined: 29 Dec 2008
Posts: 37
Location: india
|
|
|
|
while some columns expected decimal data and there is no data in first row so its abending with -310 sql error code doing insert oepration on table.
let me know for more explanation. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
still confusing...
| Quote: |
| while some columns expected decimal data |
make sure that the host variables used have the proper format and content
review/fix the program
| Quote: |
| ... there is no data in first row ... |
make sure that the first row contains the proper data,
or explain better the meaning of the sentence
( usually no data implies no row/record )
review/fix the program
review the overall application logic for the data validation/insertion/retrieval
nothing we can do from here expecially
I agree that there might be a language barrier,
but .... the explanation/description is very unexplaining/undescriptive  |
|
| Back to top |
|
|
kapil dev arora
New User
Joined: 29 Dec 2008
Posts: 37
Location: india
|
|
|
|
make sure that the first row contains the proper data
review/fix the program
This is what i wana do. Modifying program in such way so that it will validate first row.
Problem is if i just give data in first row it will validate it.
If i give data( or no data) in first row and valid data in in 2nd row it wont validate first row.
I know its confusing. But i need just a guidline just like u gave in last reply -
make sure that the first row contains the proper data
review/fix the program |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
]we are just losing time here,
we are not supposed to read minds, but I' ll give it a try
when talking about a -310 sqlcode and row everybody will associate the term row
to a database row,
going over the post for the n' th time I am making a wild guess
by row perchance you intend to refer to the first row of data on the screen?
still I stand by my opinion
fix the program in order to validate all the data that comes as input from the screen
and we cannot give any advice,
we know nothing about:
Your application, Your screen layout, the data format
ask a peer, or the consult your application guidelines on how to validate
screen data
I have seldom seen a worse description of a problem 
to solve it You are on Your own, do not expect too much help!
people are adamant to help people who describe poorly their issues |
|
| Back to top |
|
|
kapil dev arora
New User
Joined: 29 Dec 2008
Posts: 37
Location: india
|
|
|
|
I will check application flow.
Thanks again. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
All columns of all rows should have valid data.
If someone who believes it is proper to maintain a row with "bad" data, they should be removed from the design process.
If you explain what business requirement you are trying to meet and the data involved, someone may have a suggestion about how to implement.
You have not provided anything for us to use to help. All you have done is describe a very poor design and that it causes problems. |
|
| Back to top |
|
|
|
|
