substr('string',1,3) which gives str. correct me if i am wrong

Write a query to retrive partial string.

Question Posted / rajesh_m13

Answer Posted / rajesh_m13

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention the location where the output received from explain statement is stored.

1053

Where can you declare a cursor in a cobol-db2 program?

994

How do I add a column to a table in db2?

1048

What is db2? Explain.

986

What is the cobol picture clause of the db2 data types date, time, timestamp?

1007

How to test SQL -911 error while developing COB-DB2 program

7439

What is an instance database?

1003

Explain in detail about buffer manager and its functionalities?

992

What is a db2 package?

986

What is db2 command?

962

Where do you specify them?

1162

What's The Error Code For Unique Index Voilation?

1151

Why do we need reorg in db2?

919

Can one database have multiple instances?

1004

What is database reorganization?

1051