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 host variable?
Explain the benefits you can get from mainframe connect?
What is the use of reorg in db2?
What are union and union all?
What is release/acquire in bind?
What is db2 purescale?
Mention the definition of cobol in varchar field.
What do you mean by cursor?
How to test SQL -911 error while developing COB-DB2 program
B37 abend during spufi?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the latest version of ibm db2?
List out the three types of page locks that can be held.
Which components manage deadlocks in db2?
What is runstats utility in db2?