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 |
What is cascading rollback?
What is db2? Explain.
What is bind plan?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
what is the maximum number of tables that can be joined ?
What are packages in db2?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is the significance of DB2 free space and what parameters control it?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Once you create a view, where would information about the view be stored?
What are the advantages of using a PACKAGE?