Interested to Buy Any Domain ? << Click Here >> for more details...
Can you search give an array in the WHERE clause of a db2
query?
- 1 Answers
- 6629 Views
- I also Faced
- E-Mail Answers
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 different three logs in DB2?
What is cloudant database?
How to define the a field which accepts value till 99999.99 in db2
The only place of VSAM KSDS in DB2 is?
Why do we use cursor?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What are the disadvantages of PAGE level lock?
In terms of DB2 indexing, what is the root page?
How many clustering indexes can be defined for a table?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
COBOL 
