Interested to Buy Any Domain ? << Click Here >> for more details...
How do you concatenate the firstname and lastname from emp table to give a complete name?
- 0 Answers
- 1075 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is the reason behind not using select * in embedded sql programs?
What is view db2?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
max number of columns in a db2 table?
Give a brief description of db2 isolation levels?
What is image copy in db2?
What parameters are used to control the free space in DB2?
Define buffer pool.
What is auditing?
COBOL 
