View previous topic :: View next topic
|
Author |
Message |
learnmf
Active User
Joined: 14 Mar 2005 Posts: 123
|
|
|
|
Dear Friends
Quote: |
There is one db2 table.I have to perofrm search operation on various conditon on same table.
How could i do it? can it be possible by declaring ine cursor. |
Thanks and regards
Chandra |
|
Back to top |
|
|
learnmf
Active User
Joined: 14 Mar 2005 Posts: 123
|
|
|
|
I want to make you more clear about the structure
Quote: |
It is like this:-------
Suppose the TAB is a DB2 table.
If Cond-1 is true and val-1='c' and
there is no row having condintiion tab.colA='abc' and tab.colb='asd'
then display message-1
And no row found having condition tab.colA='abc' and tab.colc='jkl'
then display msg-2 |
Thanks And Reagards
Chandra |
|
Back to top |
|
|
bonniem
New User
Joined: 09 Aug 2005 Posts: 67
|
|
|
|
I must say that your question is not very clear. From what I understood you could just use 2 queries for the 2 cases, there is no need of a cursor. |
|
Back to top |
|
|
|