Into Helper

The into function is used to extract the resulting rows from a subquery or from a select into statement.

Fetch Function

The INTO helper uses a fetch function to get the row from a resulting query. The definition of the Fetch Function is described below.

var fetch = (count,rows,stmt) => 
(count && rows.next() && Array.apply(null,Array(stmt.getColumnCount())).map((_,i)
=> rows.getColumnValue(i + 1))) || [];

Into Sample Usage

Teradata

REPLACE PROCEDURE SubQuerypoc ()
BEGIN

DECLARE monat INTEGER;
SET monat      = (SELECT column1
             FROM table1);
END;

Snowflake output

CREATE OR REPLACE PROCEDURE DATAWAREHOUSE.PUBLIC.SubQuerypoc ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
 	// REGION SnowConvert Helpers Code
	
	var monat;
	EXEC(`(SELECT column1 FROM table1)`,[]);
	var subQueryVariable0;
	[subQueryVariable0] = INTO();
	monat = subQueryVariable0;
 
$$;

Into Helper function Definition

var INTO = () => fetch(ROW_COUNT,_ROWS,_RS);