Interested to Buy Any Domain ? << Click Here >> for more details...
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 do I optimize a query in db2?
Why do chiropractors use drop table?
What is cloudant database?
What does db2 stand for?
What is null indicator in db2?
Outputs of explain are with matchcols = 0. What does this signify?
What is package in db2 mainframe?
What is the physical storage length of timestamp data type?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Is ibm db2 free?
What is db2 stogroup?
How to check sequence on a table in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How to rename a table in DB2 ?
