Write a query to extract first 5 characters of a name in the column Stud_Name?
- 1 Answers
- 1944 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / shubham
select substr(Stud_Name,1,5) from Table;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is page size in db2?
What are concurrency issues?
How to test SQL -911 error while developing COB-DB2 program
What are the rules for db2 programming?
How do you find the maximum value in a column in db2?
What is a db2 table?
How to find primary key of a table in db2?
Describe major components of db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is a plan and package in db2?
What is db2 and what is the use of db2 optimizer?
What is the clustering index in the db2 database?
Can you tell me how can you find out the # of rows updated after an update statement?
Are view updateable?
What is copy pending status in db2?
