Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql abend code -801,-802?
- 2 Answers
- 27248 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yuvaevergreen
-802
Possible values for exception-type are FIXED POINT
OVERFLOW, DECIMAL OVERFLOW, ZERO DIVIDE, DIVIDE EXCEPTION,
EXPONENT OVERFLOW, or OUT OF RANGE.
| Is This Answer Correct ? | 8 Yes | 2 No |
Explain what a plan is?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is the physical storage length of time data type?
What is cloudant database?
What is a data page?
Mention some fields that are a part of sqlca.
What are the advantages of using a PACKAGE?
When is the authorization check on DB2 objects done - at BIND time or run time?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
How do I import data from excel to db2?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
what are stage one indexable predicates?
COBOL 
