passing table name during runtime

, ,
1

Hi there

Can we pass table name and column names in run time in a custom or dynamic SQL adpater service ??

Please guide me

Thanks in advance
Kiran

2

Yes you can.

Define all the input variable you may be replacing the value runtime.
For example, you can have following input variables for a DynamicSQL adapter service.

dbSchemaName
dbTableName
columnName
columnValue

and you can write you DynamicSQL as follows:

UPDATE ${dbSchemaName}.${dbTableName}
SET ${columnName} = ${columnValue}.

There is another alternative to achive the same functionality and I would prefer this alternative. Define your input as following variable

input : SQL

and write your DynamicSQL query as just : ${SQL}

Now runtime set you SQL query anything you want.

HTH.

Nilesh Gohel