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
- 9095 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the default page size of buffer pools?
Define db2.
How can deadlocks be resolved?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is buffer pool?
What is a db2 cursor?
What is blu acceleration in db2?
What do you mean by storage group (stogroup)?
Define declaration generator (dclgen).
How can you find out the # of rows updated after an update statement?
How to get the ddl of a table in db2?
Which component is responsible for processing sql statements and selecting access paths?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to connect to db2 database from windows command line?
Highlight all the advantages that are attached to a package.
