Generally if I want to select the names starting with c I
need to use c%
But how could I code to select the data which contains %
as a part of data.
Answer Posted / bala
Use '%%' to select the data which contains %
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is the syntax for creating a table in the db2 database?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is a bind card?
When do you specify the isolation level?
what is the role of the cursor in db2?
What is deadlock in db2?
What are the rules for db2 programming?
What does reorg do in db2?
What is the function of logging in the db2 database?
What is the use of dclgen in db2?
What is dclgen in db2?
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.
Explain what are the various isolation levels possible?
What is db2 bind?
How do you simulate the explain of an embedded sql statement in spufi/qmf?