|
View previous topic :: View next topic
|
| Author |
Message |
pshongal
New User
Joined: 14 Jun 2012
Posts: 96
Location: India
|
|
|
|
Hi,
I have coded as below for existence check.
SELECT 1 INTO :WS-CHECK
FROM table_name
WHERE xyz= :WS-xyz
Is it required to code it as
SELECT 1 INTO :WS-CHECK
FROM table_name
WHERE xyz= :WS-xyz
FETCH FIRST ROW ONLY --- Is this requird? |
|
| Back to top |
|
 |
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| pshongal wrote: |
| ... Is this requird? |
Yes, if your first query returns more than one row and SQLCODE -811 is not handled... |
|
| Back to top |
|
|
pshongal
New User
Joined: 14 Jun 2012
Posts: 96
Location: India
|
|
|
|
| Thank you Gnanas. |
|
| Back to top |
|
|
|
|
