Can we use dynamic table names and field names in the SQL?

Can we use dynamic table names and field names in the SQL?

book

Article ID: KB0088026

calendar_today

Updated On:

Products Versions
TIBCO IntegrationManager -
Not Applicable -

Description

Resolution:
There is a way to use Job SlotName for &lttable name>  and &ltfield name> using "^"(carat) symbol.

For eg - If they want to use the Job Slot Name for table name in the SQL statement they can write it as -

select * from ^table_name^
where table_name is the Job Slot name.

Environment

Product: TIBCO IntegrationManager Version: All OS: All --------------------

Issue/Introduction

Can we use dynamic table names and field names in the SQL?
Powered by Wolken Software