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

pls explain the precompilation process of cobol-db2 pgm

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

Explain about open switch business continuity software?

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

What is a Database Request Module(DBRM)?

wht happens if we close cursor with cursor with hold option?

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

What happens to the PLAN if index used by it is dropped?

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

When is the authorization check on DB2 objects done - at BIND time or run time?

how do you resolve -805?

What does CURRENTDATA option in bind indicate

For more DB2 Interview Questions Click Here