How is the SUBSTR keyword used in sql?
- 1 Answers
- 9505 Views
- I also Faced
- E-Mail Answers
Answer / s
Select * from emp
where SUBSTR(empname,4,2) = 'EN'
4 is the starting position and returns 2 characters after
that.
| Is This Answer Correct ? | 8 Yes | 5 No |
pls explain the precompilation process of cobol-db2 pgm
can any one expalin check point with an example?
What is the clustering index in the db2 database?
What is ACQUIRE/RELEASE in BIND?
What is rebind in db2?
What is sqlca’s maximum length?
What does sqlcabc has?
Explain an outer join?
What is innodb buffer pool?
What r the comman abends in db2, jcl and cobol???????
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What are PACKAGES ?
COBOL 
