Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins?
- 1 Answers
- 8342 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 |
My SQL is not performing well. Describe how will you fine tune it?
What happens to a cursor after a commit?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
How do you filter out the rows retrieved from a Db2 table ?
What is commit in db2?
what is sql abend code -801,-802?
What is image copy in db2?
wt is view ? wht r the restrictions for view ?
What are the full forms of spufi and dclgen and why are they used?
When Can you be sure that a query will return only one row?
How to check table size in db2 sap?
What is bind package and plan in db2?
COBOL 
