Mention a credible reason why select* is never given preference in an sql program that has been embedded.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,


How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,


what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,


I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,


i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,






How do you find the maximum value in a column in db2?

0 Answers  


Where do you specify them?

0 Answers  


How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,


What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers  


Give the COBOL definition of a VARCHAR field.

2 Answers  


What is QUIESCE?

2 Answers  


What is the use of with ur in db2?

0 Answers  


Categories