Insert in local temporary table in while loop fails

[martin.jesterhoudt]

Hi,

I'm trying to fill a temporary table within a while loop. This doesn't work. What am I doing wrong?

Within a procedure I have this kind of code:

CREATE LOCAL TEMPORARY TABLE excel_temp (LABEL STRING, WAARDE STRING);

WHILE (VARIABLES.i < 4)

BEGIN

  INSERT INTO #excel_temp (#excel_temp.label, #excel_temp.waarde) VALUES ('A', 'B'); 

  VARIABLES.i = (VARIABLES.i + 1);

END

SELECT #excel_temp.label AS c1, #excel_temp.waarde AS v1 FROM #excel_temp;

The same insert outside the loop works fine.

Regards

Martin

-- Teiid 11.1.1

[shawkins]

Can you clarify what is not working?  No rows? An exception?

[rareddy]

Also why #excel_temp at the insert? can you try excel_temp directly?

[shawkins]

To expand on what Ramesh is saying - #excel_temp is an implicit temp table, which is not the same as the explicit excel_temp. In both places you should use #excel_temp or excel_temp.

[martin.jesterhoudt]

Steven, this was the solution. Sorry for not reacting sooner but some other work and an unreachable server prevented me.