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
 

 

online abended with 310 sql error code

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
kapil dev arora

New User


Joined: 29 Dec 2008
Posts: 37
Location: india

PostPosted: Mon Apr 27, 2009 11:58 am    Post subject: online abended with 310 sql error code
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Mon Apr 27, 2009 12:01 pm    Post subject: Reply to: online abended with 310 sql error code
Reply with quote

Your explanation is confusing icon_eek.gif

what does the manual say about -310 ??
Back to top
View user's profile Send private message
kapil dev arora

New User


Joined: 29 Dec 2008
Posts: 37
Location: india

PostPosted: Mon Apr 27, 2009 12:06 pm    Post subject: -310 is coming because first row is having spaces
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Mon Apr 27, 2009 12:13 pm    Post subject: Reply to: online abended with 310 sql error code
Reply with quote

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 ...
icon_eek.gif
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 icon_rolleyes.gif
Back to top
View user's profile Send private message
kapil dev arora

New User


Joined: 29 Dec 2008
Posts: 37
Location: india

PostPosted: Mon Apr 27, 2009 12:22 pm    Post subject: You are absolutly right dear.
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Mon Apr 27, 2009 12:30 pm    Post subject: Reply to: online abended with 310 sql error code
Reply with quote

]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 icon_evil.gif

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
View user's profile Send private message
kapil dev arora

New User


Joined: 29 Dec 2008
Posts: 37
Location: india

PostPosted: Mon Apr 27, 2009 12:35 pm    Post subject: OK. Anyway thanks for your time.
Reply with quote

I will check application flow.
Thanks again.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Apr 27, 2009 6:36 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am


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