RE: Cursor Problem.
You do not have to include the INTO clause. What is the error you are
receiving? What does the cursor code that you are writing look like? Are
you using 4GL or ESQL/C?
Jamie Kohm
-----Original Message-----
From: Sujit.Pal@BankAmerica.com [SMTP:Sujit.Pal@BankAmerica.com]
Sent: Thursday, June 10, 1999 12:19 PM
To: K. BHASKAR
Cc: informix-list@iiug.org
Subject: Re: Cursor Problem.
BKR
Should you not have an INTO clause, like so:
select emp_desig_cd INTO $v_emp_desig_cd
from pmm_designation
where emp_desig_cd in (select post_cd from pmm_stn_strength)
HTH
Sujit
"K. BHASKAR" <k.bhaskar@tatainfotech.com> on 06/09/99 10:13:39 PM
To: informix-list@iiug.org
cc: (bcc: Sujit Pal)
Subject: Cursor Problem.
Hi
I have a query which works fine as a select statement.
But when used in cursor gives an error.
as in
select emp_desig_cd from pmm_designation
where emp_desig_cd in (select post_cd from pmm_stn_strength)The above select when declared as a cursor does not work.
Informix version 7.21
Also how to get Sql version
Thanks in advance
BKR