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

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

More DB2 Interview Questions

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

How can we retrieve the total number of records in RPG & CLLE?

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

How to restart a DB2 program?

What information is contained in a SYSCOPY entry?

Define check constraint.

How to create db2 table in mainframe?

Describe what a storage group(STOGROUP) is?

how can you access index

What type of database is db2?

What is meant by concurrency?

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

For more DB2 Interview Questions Click Here