Write a query to retrive partial string.

Answer Posted / rajesh_m13

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

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the max length of sqlca?

759


What is meant by dclgen?

618


Explain various types of locks in db2?

688


Why cursor is used in db2?

572


Why do we use cursor?

597






Can we update view in db2?

556


What is reorg?

617


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1234


What is deadlock in db2?

577


What is the use of value function?

622


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1709


How can deadlocks be resolved?

538


How to run db2 command in windows?

643


What is cursor stability in db2?

805


What do you mean by rollback?

572