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
i want to maintain uniqueness on pdf without make lf??????????
What is commit in db2?
How to execute stored procedures?
define clustering index.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Describe major components of db2?
What is copy pending and check pending in db2?
What is package in db2 mainframe?
What is the max length of sqlca?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Which component is responsible for db2 startup and shutdown?
Which component is responsible for processing sql statements and selecting access paths?
How can the duplicate values be eliminated from db2 select?
What is host variable?