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
- 9205 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 are bind parameters in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is plan in cobol db2?
How does coalesce work?
What action db2 takes when a program aborts in the middle of a transaction?
What is scrollable cursor in db2?
How to fetch the last row from the table in SQL (db2)?
What is the difference between drop table and delete table?
What is the use of reorg in db2?
What is meant by dclgen?
What is db2 bind?
What is runstats utility in db2?
What does reorg do in db2?
List some fields from sqlca?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
