select Y from <table> where substr(y,1,3) = 'abc' we can

in column y record
abc.v
abc.s
xyz.j
abc.h
i wan only abc columns
how to retrieve thi records

Question Posted / madhu t

2 Answers
6169 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / madhu t

select Y from <table> where substr(y,1,3) = 'abc'

we can achieve this by using substring function in sql.
SUBSTR(column-name,starting-position,length)

Is This Answer Correct ?

12 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1124

What are db2 tables?

1069

What is bind in db2?

997

List down the types of triggers in the db2 database?

988

What are the various isolation levels possible?

1071

Before you give the explain statement, what are the prerogatives?

991

What is the difference between db2 and oracle?

1082

How to retrieve rows from a db2 table in embedded sql?

1357

How many databases are there?

1015

How does cobol compile db2 program?

1023

What is syscat in db2?

966

How to find the number of rows in db2 tables?

1018

What is the clustering index in the db2 database?

970

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2355

How is a typical db2 batch pgm executed?

1128