Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins?
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 |
Which component is responsible for processing sql statements and selecting access paths?
wt is view ? wht r the restrictions for view ?
What are foreign keys?
What is null indicator in cobol db2?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
how to resolve -811
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What are the uses of db2 optimizer?
What is REORG? When is it used?
How do I delete a table in database?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the physical storage length of time data type?