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
- 9204 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 differnece between DROP TABLE & DELETE TABLE .
What is index cardinality?
What is bind and rebind in db2?
What are the three DB2 date and time data types and their associated functions?
How to fetch the uncommited data from table ?
What is the function of buffer manager?
What r the comman abends in db2, jcl and cobol???????
pls explain the precompilation process of cobol-db2 pgm
What is the maximum size of a char data type in db2?
how can u retrieve the data from null values using applicaion program.
What is rebind in db2?
What is db2 instance?
COBOL 
