Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins?
- 1 Answers
- 8333 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 a clustered index?
What is database reorganization?
Do we need cursor for Count(*)?
What is usage pointer in cobol?
What is the significance of DB2 free space and what parameters control it?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
Mention data types used in db2 ?
Explain the benefits you can get from mainframe connect?
What is IMAGECOPY ?
What is page size in db2?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
COBOL 
