Please see CommandPayload at https://docs.jboss.org/author/display/teiid830final/Statement+Extensions. Here using the TeiidStatement object you can insert a payload object ex: properties object and then can read in your custom translator through ExecutionContext.getCommandPayload object.
1 of 1 people found this helpful
To further what Ramesh said, you can also use SET PAYLOAD statements - https://docs.jboss.org/author/display/TEIID/SET+Statement that will build up a Properties object as the command payload if you don't want to use the TeiidStatement interface.
Also, Teiid 8.4 has the concept of session variables - see https://issues.jboss.org/browse/TEIID-1092 that are available via the Execution/CommandContext.
Thanks guys for prompt reply ,I checked the setPayload method and it suits the purpose.
Does ODBC support similar custom properties?
SET PAYLOAD statement will work in both JDBC and ODBC.