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 does reorg do in db2?
What is temporal table in db2?
What is null indicator in db2?
How to run db2 command in windows?
What type of database is db2?
What is the syntax for creating a table in the db2 database?
List down the data types in the db2 database.
How to take backup of table in db2?
How is a typical db2 batch pgm executed?
what are bind concepts in db2 cobol?
What is a dbrm in db2?
What are the bind parameters ibm db2?
When do you specify the isolation level?
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.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.