BEGIN DECLARE LOCAL TEMPORARY TABLE TempTab ( number INT ); ... END
2011/5/28 Sukmadi <[email protected]> > > > Kalau buat temporary table di dalam sp gimana caranya pae sqlanywhere 9.0 > > Sukmadi > Powered By Sinyal Kuat Indosat > > ------------------------------ > From: Eko Prayoga <[email protected]> > Sent: 28 May 2011 08:51 > To: [email protected] > Subject: Re: [indopb] Panggil Stored Procedure di datawindow > > > > terima kasih responya pak, sy coba dulu > > On Thu, May 26, 2011 at 11:04 AM, <[email protected]> wrote: > >> >> >> Drop - pastikan file store procedure (lupa di path \sqllib\...) Terus >> create lagi sp nya. >> Itu krn pernah restore dari sp yg tdk ada dari db terakhir. Beda ama >> sybase ase sih.. Kalo db2, script sp nya di simpan di o/s.. >> ------------------------------ >> *From: * Eko Prayoga <[email protected]> >> *Sender: * [email protected] >> *Date: *Thu, 26 May 2011 11:24:12 +0700 >> *To: *<[email protected]> >> *ReplyTo: * [email protected] >> *Subject: *[indopb] Panggil Stored Procedure di datawindow >> >> Para suhu pb, mohon pencerahannya. >> >> Saya punya Store Procedure DB2 >> *CREATE PROCEDURE MASTER.PROCEDURE1 ( )* >> * DYNAMIC RESULT SETS 1* >> * >> * >> *P1: BEGIN* >> * DECLARE cursor1 CURSOR WITH RETURN FOR* >> * SELECT * FROM MASTER.TBL_CIF;* >> * OPEN cursor1;* >> *END P1* >> >> tapi pada saat saya mau buat datawindow report terdapat error >> *SQL0444N Routine "PROCEDURE1" (specific name "SQL1105xxxxxx") is >> implemented with code in library or path "\PROCEDURE1", function >> "PROCEDURE1" with cannot accessed. Reason code : "4"* >> >> >> Mungkin ada yang pernah dapet kasus seperti ini, dan solusinya bgmn? >> Thx b4. >> >> > >
