Create cursor in NETEZZA

CREATE OR REPLACE PROCEDURE SP_NEW_PROCEDURE1( )
RETURNS REFTABLE(employees)
LANGUAGE NZPLSQL AS
BEGIN_PROC
  DECLARE

l_conditions  varchar(1000);
p_rec         RECORD;

BEGIN

FOR P_REC IN  select empid, mgrid, empname, salary  from employees where mgrid = 7 
LOOP


        l_conditions  :=  'insert into  '  || 
                          REFTABLENAME     || 
                          '  VALUES ('     || 
                          quote_literal(P_REC.EMPID)  || 
                          ','              || 
                          quote_literal(P_REC.MGRID)    || 
                          ','              || 
                          quote_literal(P_REC.EMPNAME)   || 
                          ','              || 
                          quote_literal(P_REC.SALARY )    || 
                          '  ) ; ' ;

 execute immediate l_conditions; 

  l_conditions  := ' ';

END LOOP;      
RETURN REFTABLE;
END;
END_PROC;

Source: stackoverflow.com

Similar codes

1 vote354 views1 answer
Httppostedfilebase in .net core 3.1
C#
1 vote343 views1 answer
InvalidOperationException: Calling Scene Raisefrom assembly reloading callbacks are not supported.
C#
0 vote380 views1 answer
Unity shader blend
C#Unity
11 votes345 views2 answers
How to check if an integer is in array c#
C#
0 vote344 views1 answer
Library dll unless netloaded by AutoCAD
C#
32 votes370 views2 answers
C# how to write an array in a single line
C#
2 votes318 views1 answer
Move in the direction that player is facing unity
C#
1 vote347 views1 answer
And in c#
C#
3 votes349 views3 answers
Byte array to base64 c#
C#
9 votes328 views2 answers
Get last character of string c#
C#