facing problem in sqlj
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   paresh_paladiya
Posted On:   Tuesday, June 4, 2002 01:18 PM

Hi Sir, I am writing sqlj program to create cursor for with hold status. #sql { BEGIN compound atomic static declare loTest CURSOR WITH HOLD for SELECT NOTES, NOTES1, NOTE2, NOTE3, ID FROM TEST; open :OUT loTest; END compound; }; but when I tried to compile it gives me followinf error. I tried follwoing different type of combination but it gives me same error. #sql { BEGIN Open :out loTest CURSOR WITH HOLD for SELECT NOTES, NOTES1, NOTE2, NOTE3, ID FROM TEST; END; }; If I dont write out then its compiling properly but at runtime its giving error when it tries to fire executeUpdate on exeuction context. Compiling ARTest.sqlj    More>>

Hi Sir,

I am writing sqlj program to create cursor for with hold status.

#sql { BEGIN compound atomic static
declare loTest CURSOR WITH HOLD for SELECT NOTES, NOTES1, NOTE2, NOTE3, ID FROM TEST;
open :OUT loTest;
END compound;
};

but when I tried to compile it gives me followinf error. I tried follwoing different type of combination but it gives me same error.

#sql { BEGIN
Open :out loTest CURSOR WITH HOLD for SELECT NOTES, NOTES1, NOTE2, NOTE3, ID FROM TEST;
END;
};

If I dont write out then its compiling properly but at runtime its giving error when it tries to fire executeUpdate on exeuction context.


Compiling ARTest.sqlj
D:
onWebSphereBuildsourcesqljARTest.sqlj:34.12-38.16: Error: Inaccessible Ja
va type for host item loTest (at position #1): iteratorTest.
D:
onWebSphereBuildsourcesqljARTest.sqlj:34.12-38.16: Warning: Unsupported J
ava type for host item loTest (at position #1): iteratorTest.
Total 1 error and 1 warning.

Thanks,
Paresh

   <<Less
About | Sitemap | Contact