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
How to create db2 table in mainframe?
How do I optimize a query in db2?
Explain about rct.
What are packages in db2?
How can you do the explain of a dynamic sql statement?
How to compare data between two tables in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is meant by union and union all?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What db2 400?
What is null in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Is db2 a programming language?
is it compulsory commitment control in journal?
