Answer Posted / ignatius pradeep
A Sample Query:
SELECT SUBSTR(DESC_T,1,4)
FROM PRODUCT
WHERE PROD_I = 123456;
DESC_T is a column in the table PRODUCT
The first four characters of the DESC_T will be displayed.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
is it compulsory commitment control in journal?
Are view updateable?
Explain the benefits you can get from mainframe connect?
What is the difference between bind and rebind in db2?
Define sqlca.
What is image copy in db2?
What is a dbrm in db2?
What is dbrm? When it will be created?
What is ibm db2 database?
Who uses db2?
What is a buffer in memory?
What is the difference between oracle and db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is buffer pool?
What is bind and rebind in db2?