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

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

cobol-db2 runjcl please?

max number of columns in a db2 table?

how to take the back up of the DB2 table.

Explain db2.

What is null in db2?

What are the 2 sqlcodes that are returned?

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

Give some example of statistics collected during RUNSTATS?

What is meant by union and union all?

What is a trigger in the db2 database?

what is the use of commit ? and what is the syntax?

For more DB2 Interview Questions Click Here