Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins?
- 1 Answers
- 8659 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 blu acceleration in db2?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
Can we use select * statement in cobol program without giving field names ???
What is index in db2?
Write a query to retrive partial string.
what are bind concepts in db2 cobol?
Can we insert update delete in view?
Highlight all the advantages that are attached to a package.
what is the difference between where clause and having clause
How does DB2 use multiple table indexes?
What is the difference between IN subselects and EXISTS subselect?
How do I copy a table in db2?
COBOL 
