Interested to Buy Any Domain ? << Click Here >> for more details...
Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins?
- 1 Answers
- 9112 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
DIGITS will convert INTEGER to character string
SUBSTR(DIGITS(PARTID),5,1) ='9'
This will extract the 5th character and checks to see if it
is 9.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is reorg and runstats in db2?
Define check constraint.
Explain what are the various isolation levels possible?
How can you quickly find out the # of rows updated after an update statement?
What is cursor in dbms?
What is drop table?
Differentiate between cs and rr isolation levels? Where do you specify them?
Why db2 is called db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Mention the different locking levels that are available in db2.
How will you return the number of records in table?
What are union and union all?
What is a db2 tablespace?
What is temporal table in db2?
What is runstats db2?
