Fwd: Returned mail: User unknown

sanjay soni Sun, 24 Oct 2004 22:09:40 -0700

Initially I tried to post the message from yahoo sapdb group, but somehow, it returned back. Can you please help me out with my problem, I am stuck with it. Please look at the attached message for the problem.

Thanks

Note: forwarded message attached.

Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.

--- Begin Message ---

The original message was received at Fri, 22 Oct 2004 10:42:09 +0200 (MESZ)
from n6a.bulk.scd.yahoo.com [66.94.237.40]


   ----- The following addresses had permanent fatal errors -----
<[EMAIL PROTECTED]>

   ----- Transcript of session follows -----
... while talking to listserv.sap.com.:
>>> RCPT To:<[EMAIL PROTECTED]>
<<< 550 5.1.1 <[EMAIL PROTECTED]>... User unknown
550 <[EMAIL PROTECTED]>... User unknown

Reporting-MTA: dns; smtpde02.sap-ag.de
Received-From-MTA: dns; n6a.bulk.scd.yahoo.com
Arrival-Date: Fri, 22 Oct 2004 10:42:09 +0200 (MESZ)

Final-Recipient: rfc822; [EMAIL PROTECTED]
Action: failed
Status: 5.1.1
Remote-MTA: dns; listserv.sap.com
Diagnostic-Code: smtp; 550 5.1.1 <[EMAIL PROTECTED]>... User unknown
Last-Attempt-Date: Fri, 22 Oct 2004 10:42:11 +0200 (MESZ)

--- Begin Message ---

Hi, I am very very new to SAPDB, and found it very difficult to 
understand. The kind of documentation provided with the software is 
very complex and difficult to understand and grasp.

Anyway I am using SAPDB 7.4.3 and using sqlstudio to create and test 
stored procedures.

My problem is that 
I want to write a stored procedure which picks up the data from 
table/tables, generates the resulttable and modify the result table 
and return it as a cursor to the application or programme.
So the final aim is to modify the result table and not the original 
data, and return the modify data as a cursor.

For this I have written a test procedure, which compiles properly. 
But when I call it from SQL Studio, I get the error message 

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-4024 .
call TESTDBPROC2


And here is the code of the stored procedure.


CREATE DBPROC TestDBProc2 returns cursor as
VAR tmpName varchar(255); tmpAddress varchar(255);

DECLARE TestCursor CURSOR FOR
Select * from PMP_OWNER.TESTTABLE FOR REUSE FOR UPDATE OF address;

WHILE($rc = 0) DO
BEGIN
    Fetch NEXT TestCursor INTO :tmpName, :tmpAddress;
    IF($rc = 100) THEN break;
    Update PMP_OWNER.TestTable SET Address = 'abc' where current of 
TestCursor;
END;

DECLARE ReturnCurosr CURSOR FOR
Select * FROM PMP_OWNER.TestCursor;



Can anybody please help me out??? It is very urgent, I am struggling 
with this since last 3 days and not finding any help.

--- End Message ---

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: Returned mail: User unknown

Reply via email to