17 Replies Latest reply: Jul 4, 2012 8:57 PM by Vineet Vivekanand Kulkarni RSS

how to send in parameters when using result view

Rajarshi Muhuri
Currently Being Moderated

CREATE TYPE DEVGUIDE.PCPTYPE AS TABLE ( LOCATION NVARCHAR (60), ANNUAL_PRECIPITATION REAL);

CREATE PROCEDURE DEVGUIDE.GETCOLDPRECIPITATION (IN LOW_TEMP INTEGER, OUT PRCPT DEVGUIDE.PCPTYPE)

LANGUAGE SQLSCRIPT READS SQL DATA WITH RESULT VIEW PROCVIEW AS

BEGIN

PRCPT = SELECT LOCATION , ANNUAL_PRECIPITATION FROM DEVGUIDE.LOCAL_CLIMATE WHERE TEMPERATURE_LOW = :LOW_TEMP ;

END;

First Question :

1. The Type Tables ( which are not physical tables) seem to be ROW tables , if this is true then , should we really use them (keeping performance in mind) since there is a internal flip from ROW to COLUMN storage.

 

Second Question

2.Whats the syntax to pass IN params while using the result view

select * from PROCVIEW with parameters ( ?? )

 

I am able to call the procedure as CALL DEVGUIDE.GETCOLDPRECIPITATIONX(-2, null );

Actions