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

1 Answers
2658 Views
RBS, I also Faced
E-Mail Answers

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 package in cobol db2?

0 Answers

What is the function of logging in the db2 database?

0 Answers

What is a view? Why use it?

2 Answers

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers Wipro,

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers Accenture,

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers Mphasis,

How can you find out the # of rows updated after an update statement?

0 Answers

What else is there in the PLAN apart from the access path?

1 Answers

What is a result table?

1 Answers

What is db2 optimizer?

0 Answers

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers IBM,

B37 abend during spufi?

0 Answers IBM,

For more DB2 Interview Questions Click Here