what is sql abend code -801,-802?

Answer Posted / lu

first of all, i suggest you to read errors messages if you
get any error before asking (always learning
yourself) ...in db2 you have a lot...a lot error....
now
sqlcode = -801, -802 it's mean you try to divide your
column by zero....

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the advantage in De-normalizing tables in DB2?

964


Explain how can you do the explain of a dynamic sql statement?

885


What is the difference between cursor and select statement?

887


How to view db2 table structure?

819


What is the cobol picture clause of the db2 data types date, time, timestamp?

860


How to access db2 tables in mainframe?

837


Explain the function of data manager.

832


What is access path in db2?

759


What is a collection in db2?

801


How do you select a row using indexes in db2?

875


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2583


What is the difference between plan and package in db2?

864


How to create db2 table in mainframe?

885


What is null in db2?

779


What is bufferpool in db2?

829