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
- 9094 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 contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is the result of open cursor statement?
what is the maximum number of tables that can be joined ?
What is the use of db2 optimizer?
What is the physical storage length of date data type?
what is consistency token
What are the three DB2 date and time data types and their associated functions?
In terms of DB2 indexing, what is the root page?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What is the SQL Communications Area and what are some of its key fields?
What is the meaning of -805 SQL return code?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
COBOL 
