Can you search give an array in the WHERE clause of a db2
query?
Answer Posted / ram prajapati
arrays are not supported by sql so trying to add an array in
a where clause of sql may throw some errors...
only dot operators are possibly used...
plz correct me if i'm wrong
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What are union and union all?
How to take backup of table in db2?
What are db2 tables?
Define buffer pool.
What is temporal table in db2?
How do I create a view in db2?
What is the purpose of rollback and commit?
What are the different types of base tables?
can we view the access paths created by dbrm ? how ? thx
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What are the contents of a dclmgen?
What happens in bind step in a db2 program?
What is rct?
What are the contents of dclgen?