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 are db2 objects?

816

What is page size in db2?

727

What is rebind in db2?

765

What is the use of db2 optimizer?

809

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2643

Explain about rct.

851

What are the contents of a dclmgen?

822

What is db2 command?

766

What's The Error Code For Unique Index Voilation?

854

Define declaration generator (dclgen).

868

What are packages in db2?

776

What is a db2 cursor?

795

How do I delete a table in database?

773

What is a collection in db2?

764

What is declare cursor?

803