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
- 9119 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 |
how do u update the faltfile into db2 table ?
What is the syntax required for the creation of a cursor?
What are the three types of page locks that can be held?
What is a composite index and how does it differ from a multiple index?
Update command
What's the difference between DB2 active log and archive log? Thanks a lot...
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
How can you display the current date & current time ?
How to check sequence on a table in db2?
how to resolve -818 error. how to see timestamp token in load module and plan
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How do I import a csv file into db2?
COBOL 
