How do you retrieve the first 5 characters of firstname column of db2 table emp?
Answer / ankit
Select substr(firstname,1,5) as firtname from emp;
| Is This Answer Correct ? | 0 Yes | 0 No |
What is release/acquire in bind?
What is meant by explain?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is innodb buffer pool?
When do you use the IMAGECOPY?
i want to delete 20th million record how ?
What is a lock?
How do you insert a record with a nullable column?
What is index in db2?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
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 the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?