Interested to Buy Any Domain ? << Click Here >> for more details...
what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??
- 4 Answers
- 14134 Views
- Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sachin
-100 when the rows found.
-805 plan not found
-305 null indicator not declared
-104 invalid keyword
-199 illegal use of keyword
-206 table not foung
-310 for decimal column using non decimal
-407 try to insert the null value in the not null column
-501 try to close the curosr which are already open
-811 multirow select
-504 cursor not decalred
-818 time stamp mismatch
-180 date error
-181 date and time are invalid
-414 in the union the column are not same
-911
-913 both are for the deadlock
-904 for the resource not avable
-922 authorization failure
-924 coneection is not availbke
| Is This Answer Correct ? | 4 Yes | 0 No |
Give a brief description of db2 isolation levels?
In which column of which DB2 catalog would you find the length of the rows for all tables?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is the use of value function?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
Write a query to extract first 5 characters of a name in the column Stud_Name?
What do you need to do before you do EXPLAIN ?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is multi row fetch in db2?
What are the three DB2 date and time data types and their associated functions?
how can we find nth max salary from A table
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
COBOL 
