Kalau buat temporary table di dalam sp gimana caranya pae sqlanywhere 9.0 Sukmadi Powered By Sinyal Kuat Indosat
----- Original Message ----- 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.
