what are the frequent DB2 abends did you encounter in your programs ?? What ar

what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ??

Question Posted / nimsatprasad

4 Answers
14329 Views
Xansa, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL aben..

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

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL aben..

Answer / vijay

-805

Is This Answer Correct ?

3 Yes

1 No

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL aben..

Answer / dinesh

-84 unacceptable sql statement

Is This Answer Correct ?

0 Yes

0 No

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL aben..

Answer / rock

1)-206
2)-805
3)100

Is This Answer Correct ?

1 Yes

5 No

Post New Answer

More DB2 Interview Questions

how 2 resolve the -311 sqlcode

1 Answers

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.

1 Answers

Explain about rct.

0 Answers

What is a root page?

1 Answers

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers

What is a buffer pool?

2 Answers

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers TCS,

How does one remove entries from the SCT02 table?

1 Answers

What is db2?

0 Answers

select 100 records from million records ?

2 Answers Verizon,

What is the difference between CS and RR isolation levels?

1 Answers

how to resolve -811

2 Answers IBM,

For more DB2 Interview Questions Click Here