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


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

Post New Answer

More DB2 Interview Questions

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  


assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,


What is the use of dclgen in db2?

0 Answers  


what is + sign and -ve sign for sql code ?

1 Answers   TCS,


What is sqlca?

0 Answers  






what is the process of precompiler?

2 Answers  


how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,


How will you return the number of records in table?

0 Answers  


What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  


How many sub queries can you combine together ?

4 Answers   IBM,


How do I import a csv file into db2?

0 Answers  


How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


Categories