Can you search give an array in the WHERE clause of a db2
query?
Answer / 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 |
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
How do I import data from excel to db2?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is cursor?
What is load utility in db2?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
When the like statement is used?
What is access path in db2?
what is cursor stability?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?