Interested to Buy Any Domain ? << Click Here >> for more details...
can any one give the list of some important sql abend codes
which r frequently asked in interviews?
- 2 Answers
- 8654 Views
- I also Faced
- E-Mail Answers
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 the difference between nvl and coalesce?
Is there any advantage to denormalizing DB2 tables?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is meant by repeatable read?
Mention data types used in db2 ?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
What is the difference between base table and view?
What is the use of value function?
When is the authorization check on DB2 objects done - at BIND time or run time?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
COBOL 
