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 |
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What are db2 objects?
Which transaction use a command thread ?
what is rebinding ?
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 is runstats and reorg in db2?
What is EXPLAIN?
Can you define an Index if the table size less than 10 PAGES?
What's The Error Code For Unique Index Voilation?
What is the SQL Communications Area and what are some of its key fields?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........