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
- 9005 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
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Define sqlca.
What do you mean by storage group (stogroup)?
How to retrieve rows from a db2 table in embedded sql?
How to create backup table in db2?
How do I create a view in db2?
What are db2 tables?
What is iseries database?
What is alias in db2?
What is a system catalog table in db2?
When reorg is used?
What is the advantage in De-normalizing tables in DB2?
What is the maximum size of a char data type in db2?
How to get the ddl of a table in db2?
