Write a query to retrive partial string.
- 2 Answers
- 4744 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh_m13
substr('string',1,3) which gives str. correct me if i am wrong
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
what is the Foreign key? explain?
What is sqlca’s maximum length?
What types of tables are there in the db2 database?
can i code union in cobol-db2 pgm ?
Is db2 a programming language?
pls explain the precompilation process of cobol-db2 pgm
Can any one tell me about Restart logic in DB2.
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
what is difference between Plan and Package
What does DML stand for and what are some examples of it?
COBOL 
