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
Mention the definition of cobol in varchar field.
Explain correlated sub-queries.
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What are union and union all?
Why db2 is called db2?
What is cobol db2?
On which levels locks can be applied?
Which isolation level provides highest data integrity?
How do I import data from excel to db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
How can record locking be achieved in those DB2 versions which do not support it?
What is precompiler in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Explain about rct.
Explain what are the various isolation levels possible?