Interested to Buy Any Domain ? << Click Here >> for more details...
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
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?
How do I delete a table in database?
Give a brief description of db2 isolation levels?
Explain the benefits you can get from mainframe connect?
Where can you declare a cursor in a cobol-db2 program?
How does a cursor work?
What are the different types of base tables?
What is the physical storage length of date data type?
How would you find out the total number of rows in a db2 table?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is dbrm? When it will be created?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
what is a corelated subquerry?
What is the difference between cursor and select statement?
What is ibm db2 connect?
