Generic reference to parameter in procedure

martin.jesterhoudt Apr 5, 2018 10:12 AM

Hi,

Is there a way to referr dynamically to a given parameter in a procedure? Situation:

Parameters: F1, F2, F3, F4

BEGIN

DECLARE NUMBER VARIABLES.i;

CREATE LOCAL TEMPORARY TABLE TEST (A STRING);

WHILE (VARIABLES.i < 5)

BEGIN

INSERT INTO TEST (F1|F2|F3|F4); <-- SOMETHING MAGICAL HERE!

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

END

SELECT * FROM TEST;

END

1. Re: Generic reference to parameter in procedure

rareddy Apr 5, 2018 11:32 AM (in response to martin.jesterhoudt)
This does not work?

BEGIN IF INSERT_TO_F1 INSERT INTO TEST (F1); ELSE IF INSERT_TO_F2 INSERT INTO TEST (F2); END VARIABLES.i = (VARIABLES.i + 1); END
Actions
2. Re: Generic reference to parameter in procedure

martin.jesterhoudt Apr 5, 2018 11:41 AM (in response to rareddy)

Yes it does but it is not what I want since I will have to deal with a lot of parameters. Is there a limit in the number of parameters? I will need hundreds...
Actions
3. Re: Generic reference to parameter in procedure

rareddy Apr 5, 2018 11:58 AM (in response to martin.jesterhoudt)

Then another option is to use the "EXECUTE IMMEDIATE" command and generate the command with IF/ELSE blocks. See Procedure Language · Teiid Documentation Dynamic SQL Command
Actions