Answer Posted / s
Select * from emp
where SUBSTR(empname,4,2) = 'EN'
4 is the starting position and returns 2 characters after
that.
Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is null value in db2?
Explain dclgen.
What is temporal table in db2?
Who uses db2?
Comment whether the cursor is closed during commit or not.
What is dbrm? When it will be created?
What is syscat in db2?
How many types of page locks can be held in db2?
Can there be more than one cursor open for any program?
How can we read records for specific member in CL? AND rpg?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the default page size of buffer pools?
What is data manager?
What is role in db2?
what is the responsibility of the construction superintendent