Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Write a query to extract first 5 characters of a name in the column Stud_Name?

Question Posted / manjunath


Write a query to extract first 5 characters of a name in the column Stud_Name?..

Answer / shubham

select substr(Stud_Name,1,5) from Table;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the use of reorg in db2?

0 Answers  

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

Mention data types used in db2 ?

0 Answers  

Explain the benefits you can get from mainframe connect?

0 Answers  

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

How do you insert a record with a nullable column?

2 Answers  

What is db2 bind?

0 Answers  

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

What is db2?

0 Answers  

What is a predicate?

1 Answers  

Are view updateable?

0 Answers  

For more DB2 Interview Questions Click Here
Categories