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 |
How to define the a field which accepts value till 99999.99 in db2
How to execute stored procedures?
Define buffer pool.
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is db2 catalog database?
What is an instance database?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the difference between oracle and db2?
how to unload different table data into different gdg files/ vsam files.
What is deadlock?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?