Why select is not preferred in embedded sql programs?

914

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

790

can we view the access paths created by dbrm ? how ? thx

6627

What is the role of union all and union

853

What is copy pending status in db2?

846

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

842

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

830

What kind of database is db2?

763

What is db2 optimizer?

979

Which command is used to remove all rows from a table?

754

What is the difference between bind and rebind in db2?

1160

What is the maximum length of sqlca?

1100

On which levels locks can be applied?

843

When do you specify the isolation level?

785

Give the name of some fields form sqlca.

803