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
- 9006 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 a Cartesian product?
When would you prefer to use VARCHAR?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
what is the sqlcode -501
List out the buffer pools in db2
Do we need cursor for Count(*)?
What is load replace in db2?
Where besides the DB2 catalog is database object information stored by DB2?
What is the difference between nvl and coalesce?
select 100 records from million records ?
How does cobol compile db2 program?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
COBOL 
