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.
- 5 Answers
- 7106 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
C% will work for all the cases. Even if the data contains
%, Using C% will fetch that too.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is consistency token in db2?
Explain correlated sub-queries.
What is null indicator in db2?
How do you find the maximum value in a column in db2?
What happens in bind step in a db2 program?
List down the types of triggers in the db2 database?
What does runstats do in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is db2 command?
Explain the contents that are a part of dclgen.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How to run db2 command in windows?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Differentiate between cs and rr isolation levels? Where do you specify them?
B37 abend during spufi?
