How do you retrieve the first 5 characters of firstname column of db2 table emp?
Answer Posted / ankit
Select substr(firstname,1,5) as firtname from emp;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which isolation level provides maximum concurrency?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is a db2 collection?
What is the use of db2 optimizer?
What is a cursor in programming?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What do you mean by between and in? Is between inclusive of specified range values?
Can there be more than one cursor open for any program?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is db2 plan table?
How do I copy a table in db2?
Which isolation level provides highest data integrity?
How do we specify index to include or not during bind process.
What is cursor with hold option in db2?
What is the maximum number of columns in a db2 table?