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


Please Help Members By Posting Answers For Below Questions

How is the value function used?

606


How do I delete a column in db2?

682


List some fields from sqlca?

615


What is bind package and plan in db2?

597


What is load replace in db2?

562






What is db2 connect?

612


What is access path in db2?

566


What is bind in db2?

608


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1628


How can you do the explain of a dynamic sql statement?

637


Explain dclgen.

728


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

628


What is node in db2?

610


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

656


What os does db2 run on?

574