This content has been marked as final.
Show 3 replies
-
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
-
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...
-
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