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
6122 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

Define predicate?

1062

How to create db2 table in mainframe?

1096

Can there be more than one cursor open for any program?

1121

Explain db2.

987

What is a db2 schema?

1172

What is the function of logging in the db2 database?

1066

What are the uses of db2 optimizer?

1221

What is the usage of open cursor command?

1032

What is package in cobol db2?

1073

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1134

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

2166

Discuss about db2 bind?

1046

What are foreign keys in db2?

1031

What is the information associated with sysibm.syslinks table?

1055

How does db2 sample database connect?

966