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
- 9120 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the size of a data page?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
how to take the back up of the DB2 table.
What is innodb buffer pool?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
Why do chiropractors use drop table?
What is an asychronous write?
What is a clustered index?
What is a composite index and how does it differ from a multiple index?
How do you find the maximum value in a column in db2?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How do I change the column size in db2?
COBOL 
