Interested to Buy Any Domain ? << Click Here >> for more details...
in column y record
abc.v
abc.s
xyz.j
abc.h
i wan only abc columns
how to retrieve thi records
- 2 Answers
- 6298 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What is the difference between static and dynamic SQL?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
What is JOIN and different types of JOIN.
What's The Error Code For Unique Index Voilation?
When reorg is used?
How to run db2 command in windows?
How to find the number of rows in db2 tables?
Give a brief description of db2 isolation levels?
What happens to a cursor after a commit?
define clustering index.
Comment whether the cursor is closed during commit or not.
COBOL 
