Answer / mdvasanth86

Anand is right.


SELECT * FROM table_name WHERE column_name LIKE 'C!%'
ESCAPE'!';


If you want to use % or _ as part of your like clause,
you must have an escape character before each occurrence of
% or _ and define what the escape character is like above.

So, an escape character before the % or _ will make it part
of the string rather than a wildcard character(S).


HTH

Answer / bala

Use '%%' to select the data which contains %

Answer / guest

C% will work for all the cases. Even if the data contains
%, Using C% will fetch that too.

Answer / prachi

SELECT NAME FROM EMP WHERE NAME LIKE 'C%';

Answer / anand

hi,
it may be correct ans.check out this..
SELECT * FROM table_name WHERE column_name LIKE 'C%%'
ESCAPE'%';

what is the use of cursors?

3 Answers   iGate,

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

Is db2 a database?

0 Answers  

Define predicate?

0 Answers  

How to find schema of a table in db2?

0 Answers  

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

2 Answers  

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,

What are the contents of a dclmgen?

0 Answers  

What else is there in the PLAN apart from the access path?

1 Answers  

How do you find the maximum value in a column in db2?

0 Answers  

What is commit in db2?

0 Answers