Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins?

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


Please Help Members By Posting Answers For Below Questions

Why select is not preferred in embedded sql programs?

976


What is the use of value function?

877


What is data manager?

829


What are packages in db2?

817


What is a collection in db2?

804


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11415


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1869


What is the syntax for FETCH in DB2 ?

953


Mention the definition of cobol in varchar field.

929


Can there be more than one cursor open for any program?

936


Can you tell me how can you find out the # of rows updated after an update statement?

908


What is dbrm? What it contains? When it will be created?

823


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 .....

2142


How many databases can be created inside an instance in db2 ?

842


What is db2 bind process?

977