can any one give the list of some important sql abend codes
which r frequently asked in interviews?
Answers were Sorted based on User's Feedback
Answer / s.v.venkata sivaprasad
0 successful execution and row found
100 successful but row nt found or end of file
-818 time stamp token mismatch
-811 multiple rows retrieving by using sql statement in
application program
-911/-913 time out due to dead lock
-904 plan not found corresponding load module
-305 null valule
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / hussain
yes sure y not..i have all the imp sql abend codes..
1.dondu kala 0012
2.babu jhelale 6.5
3.kanyum kaana version 5.09
4.babu bisleri8.3
5.baiju bawara on the rock
6.shakira rocking girl
ab aur kya bataaoun bhai bol ...kuch aur puchna hai
to email jaror krna ..dhnyawaad..:)
Is This Answer Correct ? | 3 Yes | 18 No |
Outputs of explain are with matchcols = 0. What does this signify?
What are data types?
What can the SET option of the Repair Utility accomplish?
What is netezza database?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What are the functions in DB2?
What is a page in db2?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
WHAT IS MEANT BY COMMIT COMMAND?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What are the three lock types?