How do you retrieve the first 5 characters of firstname column of db2 table emp?
- 1 Answers
- 1495 Views
- I also Faced
- E-Mail Answers
Answer / ankit
Select substr(firstname,1,5) as firtname from emp;
| Is This Answer Correct ? | 0 Yes | 0 No |
How can you quickly find out the number of rows updated after an update statement?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
where will u check for sqlcode ?
What is a cursor and what is its function?
Return code 100 means?
What is read-only cursor?
What does the REORG Utility do?
what is rebinding ?
What is the use of reorg in db2?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the picture clause of null indicator variable?
COBOL 
