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 |
What is pagespace?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
what is dynamic cursor?gives syntax for this?
Which command is used to remove all rows from a table?
How can you quickly find out the number of rows updated after an update statement?
What is the difference between group by and order by?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the command used by TSO users to invoke DB2?
what is check point and restart Logic ? why do we go for that ??
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
Suppose if I need to update a column, how you do that using cursor?
How do I import data from excel to db2?