You need to display SQL-ERR-D variable from SQL CA on your program. It will

how to u check the query is executing or not ?where will u check for sqlcode ?

Question Posted / nithinbalaji mariappan

Answer Posted / nithinbalaji mariappan

You need to display SQL-ERR-D variable from SQL CA on your program. It will write a sql error code

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What parameters are used to control the free space in DB2?

1056

What is the use of predicate?

1042

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

What is the usage of open cursor command?

1100

What is load utility in db2?

1181

What is db2 command?

1036

What are catalog tables in db2?

1049

What is db2 bind?

1082

Define buffer pool.

1054

How to restart a DB2 program?

1902

What is multi row fetch in db2?

1050

What language is db2 written in?

1047

How do you concatenate the firstname and lastname from emp table to give a complete name?

1076

Name the lockable units in DB2?

1128

Comment whether the cursor is closed during commit or not.

1105