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
- 9125 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 coalesce in db2?
What are the isolation levels possible ?
How to resolve -504 sql code in DB2?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What do you mean by rollback?
how do we solve soc 7 and soc4 ?
what is diffrence b/w file-aid tool and file-aid utility???
What information is held in SYSIBM.SYSCOPY?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How do I optimize a query in db2?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
COBOL 
