where will u check for sqlcode ?

Question Posted / visu.kanchamreddy

2 Answers
6973 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

where will u check for sqlcode ?..

Answer / shaan

Be sure to include sqlca in working storage section.
Then you can check sqlcode from the copybook variable SQLCODE.

Is This Answer Correct ?

15 Yes

0 No

where will u check for sqlcode ?..

Answer / guru

If you dont include SQLCA, Define SQLCODE and SQLSTATE as
working storage variables and This will suffice

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More DB2 Interview Questions

What is filter factor?

2 Answers

Explain the function of data manager.

0 Answers

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers IBM,

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers IBM,

Define predicate?

0 Answers

What is DCLGEN ?

2 Answers

What is DB2 (IBM Database 2)?

3 Answers

what is SPUFI ?

2 Answers

Mention the different locking levels that are available in db2.

0 Answers

How to find last record before record through SQLRPGLE?

1 Answers IBM,

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers Wipro,

For more DB2 Interview Questions Click Here